New Performance Optimisation for Excel PivotTables Connected To Power BI Semantic Models
Some good news: an important optimisation has rolled out for Excel PivotTables connected to Power BI semantic models! Back in 2019 I wrote about a very common problem affecting the MDX generated by PivotTables connected to Analysis Services where, when subtotals are turned off and grand totals are turned on, the query nevertheless returns the … Continue reading New Performance Optimisation for Excel PivotTables Connected To Power BI Semantic Models
Published on:
Learn moreRelated posts
Fabric Fridays #118 - DAX Columns vs NO DAX Columns
17 hours ago
What now for Power BI? The question I can’t escape
Everyone keeps asking me the same question: what now for Power BI? With Microsoft Fabric reshaping its identity and AI-generated dashboards ch...
3 days ago
Mastering DAX 3rd Edition Unplugged
4 days ago
Setting up Power BI Version Control with Azure Dev Ops
In this blog post is a way set up version control for Power BI semantic models (and reports) using the PBIP (Power BI Project) format, Azure D...
4 days ago
Chat with Copilot inside a report on the Power BI mobile app (Preview)
If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform”...
5 days ago
Power BI TMDL Security Roles Done Right
10 days ago