Power BI

New Performance Optimisation for Excel PivotTables Connected To Power BI Semantic Models

Chris Webb's BI Blog
New Performance Optimisation for Excel PivotTables Connected To Power BI Semantic Models

Summary

Key performance optimization for Excel pivot tables connected to Power BI semantic models: fewer unnecessary subtotals in MDX.

Read the full article

Related articles

Chris Webb's BI Blog · 11 Mar 2026

Using Claude Code + Paper.design MCP to generate Power BI wireframe backgrounds from a markdown spec
Chris Webb's BI Blog · 10 Mar 2026

Fabric GPS - Microsoft Fabric Roadmap Tracker
Chris Webb's BI Blog · 10 Mar 2026

Creating functions for the like for like DAX pattern
Chris Webb's BI Blog · 10 Mar 2026

Why choose a Data Warehouse for Gold instead of a Lakehouse?