PowerPivot/PowerView/PowerQuery/PowerBI

Technical Article

Performance Design Tip for Power BI: Be Careful of Dates

  • DatabaseWeekly

I have written about Date Dimension in Power BI in many posts, and it makes sense now to explain one of the most common performance challenges that I see in some of the models. Sometimes, your model size grows significantly big, and you have no idea...

You rated this post out of 5. Change rating

2019-03-30

Technical Article

Power BI, Caching, Parallelism And Power Query Refresh Performance

  • DatabaseWeekly

Some time ago a customer of mine (thank you, Robert Lochner) showed me a very interesting scenario where a set of Power Query queries in Power BI Desktop refreshed a lot faster with the “Enable Parallel Loading Of Tables” option turned off.

You rated this post out of 5. Change rating

2019-03-30

Blogs

Code signing for mere mortals

By

Well, turns out code signing is pretty complex, so I’m writing this blog post...

Blogging for the Tech Professional at Denver Dev Days

By

For those that attended my talk at Denver Dev Days, here are the slides:...

Getting AI Written Unit Tests

By

As a part of my AI experiments, I decided to ask CoPilot to write...

Read the latest Blogs

Forums

Software Flexibility (Avoiding the next hack)

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Software Flexibility (Avoiding the next...

Roles on tempdb

By cphite

A co-worker asked me a question today and I couldn't come up with an...

Delayed tcp acknowledgement registry setting

By Rasmus Remmer Bielidt

Our IT department contacted me recently and asked if they should change the default...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers