This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI.
Read more
Sample query plan


Another year has gone by and it has now been 10 years since DAX was first introduced in late 2009. As usual, it is time to review the past year and to take a look at the year ahead.
Read more


Courses highlights
Kick off 2020 by learning DAX at one of our live workshops!
Last few days of early bird discount for:

  Houston (Feb 5-7) Early Bird

  San Diego (Feb 11-13) Early Bird

  Amsterdam (Feb 18-20)


Latest news
• Introducing the Power BI Activity Log
Microsoft released a new Power BI API called the activity log, which enables Power BI service admins to track user and admin activities within a Power BI tenant.
Dec 21,2019 · Microsoft
• New “Diagnose Step” Power Query Feature In Power BI
Chris Webb introduces a feature included in the December 2019 release of Power BI Desktop, the “Diagnose Step” button on the Tools tab of the Power Query Editor ribbon. This was not mentioned in the release blog post from Microsoft, so you probably missed it just like we did!
Dec 23,2019 · Chris Webb
• On-premises data gateway December 2019 update
We would like to stop mentioning data gateway updates when the automatic update is available. Until then, remember to update your gateway!
Dec 26,2019 · Microsoft
• Azure Synapse Analytics & Power BI concurrency
James Serra discusses concurrency issues using Azure Synapse Analytics and Power BI. There ain't no such thing as a free lunch, not even in the cloud.
Dec 27,2019 · James Serra
• Aggregations and Time Series calculations in Power BI
Shabnam Watson describes how to use Power BI aggregations to cover time series calculations such as Year to Date, Quarter to Date, and Month to Date. You always need to pay attention to the details.
Dec 30,2019 · Shabnam Watson
• Data Color Reference for Power BI Themes
David Eldersveld describes how to get the hex color reference for the themes in Power BI Desktop. Sooner or later, you will need to retrieve exactly one of those colors...
Dec 31,2019 · David Eldersveld