Power BI Weekly
Issue #359 - 26th May 2026
Only one bit of Microsoft content this week, which is the post on the Fabric Community Blog introducing TOMPo MCP: AI-Powered Lineage Intelligence for Power BI & Microsoft Fabric, a tool that traces the complete data journey from semantic model columns and measures back through your Fabric items. If you've ever spent time manually piecing together lineage, it's worth a look. Elsewhere, Jiří Neoral has written (in Czech, browser translation recommended for non-Czech readers!) a thorough overview of the history of writeback in BI models in Úpravy dat v BI modelech: od SSAS přes Power Apps až po Fabric Planning, covering everything from SSAS Multidimensional through to the new Fabric Planning item. And finally, Justin Martin walks through a clever approach to Agentic Power Query Development, using PQTest to let an LLM write and self-correct Power Query M code without ever touching your PBIX or semantic model.
🛠️ Data Prep
- Justin Martin (@dax_noob_justin) writes about Agentic Power Query Development
- On the Power BI community blog, Hans-Georg Puls writes that Distinct is not the same for Power Query and DAX – but that's not the whole story.
- Jason Cockington (@JasonCockington) talks about The Optimal Shape for Power BI Data
- Fiona Umpa shares some Power BI Tips - Create Parameters and Create GROUPS in Power Query Editor to organise your queries
🧩 Data Modeling
- On the Tabular Editor blog, Bernat Agulló Roselló (@AgulloBernat) writes about When DAX UDF measures beat calculation groups for time intelligence
- Edward (Ned) Charles presents Understanding DAX Queries (Before You Let AI Write Them)
- Fiona Umpa talks about Using VARIABLES and COMMENTS in measures and calculated columns
- On the Learning Science YouTube channel, Learning Science describes How to Distribute Monthly Values by Week in Power BI
- On the Power BI community blog, Parul Rani Sagar talks about DAX User-Defined Functions: Reusable Logic, Typed Parameters, and Smarter Evaluation
- Chandeep Chhabra (@chandeep2786) discusses The Simplest Way to Connect Claude and Power BI
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) talks about No Code Power BI - Claude and Power BI Modeling MCP Server
📊 Report Authoring and Interactivity
- On the Power BI community blog, Tushar Pardeshi blogs about TOMPo MCP: AI-Powered Lineage Intelligence for Power BI & Microsoft Fabric
- Bas Dohmen (@HowToPowerBI) talks about AI Can Now Build ANY Power BI Chart You Want
- On the Power BI Tips YouTube channel, Mike Carlo and Tommy Puglia (@PowerBITips) talk about Agentic Skill & Report Design - Ep.530 - Power BI tips
- Jiří Neoral (@JiriNeoral) covers Úpravy dat v BI modelech: od SSAS přes Power Apps až po Fabric Planning [Czech]
- Pankaj Namekar hosts Deneb for Power BI Custom Visuals, Guided Design & Reusable Templates with Harsh Joshi
- Amit Chandak (@amitchandak78) shares a Power BI Matrix Trick: Show Budget Only in Grand Total Using Calculation Groups
- Alex_RM describes How To: Display All Selected Filters at Once
- Mike Steedle writes that Slicers are not self-aware