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
Power BI, Parallelism And Dependencies Between SQL Queries In DirectQuery Mode
This is going to sound strange, but one of the things I like about tuning Power BI DirectQuery semantic models is that their generally-slower ...
12 hours ago
Creating Engaging, Animated Line Charts in Power BI with Custom Visuals
Power BI provides powerful built-in visuals, but sometimes you need custom behavior—such as animated line transitions when filters change. In ...
2 days ago
Generate ERD diagrams for your Power BI Semantic Model using GitHub Copilot
While preparing for a training day I will host early March, I was doing some experiments in VS Code with GitHub Copilot and a few related exte...
5 days ago