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


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



Azure Workbooks


I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet


A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

SQL Server Quickie #46 – SQL Server on Linux


Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Read the latest Blogs


The World of Data Science

By urmila880

Comments posted to this topic are about the item The World of Data Science

PowerQuery in SSIS... is it only in 2023?

By pietlinden

First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...

Slicing status based on conditions

By MrRobot

Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers