Power BI Weekly
Issue #350 - 24th March 2026
This week we have all the FabCon related Power BI content, in case you missed anything last week. The main blog, written by Arun Ulag, can be found here: FabCon and SQLCon 2026: Unifying databases and Fabric on a single data platform, putting databases right at the forefront of this year's messaging. You won't see much Power BI content in there, but if you're using Fabric (which I'm sure many of you are), it's well worth taking a read of that to get your summary. If you want the Power BI round-up, then that's been written by Mohammad Ali, titled: Semantic Layers: The foundation of enterprise AI, highlighting the main announcements:
- The GA of Translytical Task Flows
- The desperately-needed "Modern visual defaults" (see a deep dive here: Deep Dive into Modern Visual Defaults and Customizing Theme Improvements (Preview)). By default, reports now look much slicker and aesthetically pleasing (IMHO)
- The preview of Report Copilot for Mobile
- The introduction of TMDL View on the Web (Preview), bringing the power of scripted changes to your model into the browser, where Version History is supported and previewing changes is supported through the "View" mode
- The GA Direct Lake on OneLake
- The Preview of Direct Lake Calculated Columns, including a new "user-context aware" capability which allows for "dynamic" columns based on user-specific DAX functions like UserCulture(), UserPrincipalName(), and CustomData() 🤯
- The GA of various Table Visual Updates (including new, easy options for overriding totals)
Even more updates can be found in the Power BI March 2026 Feature Summary, which was also released last week. Another announcement over on the Fabric blog was the GA of the On-premises data gateway auto-update (admin triggered), enabling on-demand manual or programmatic updates to your Gateway. And today we've been told about the GA of Workspace Tags, providing even more options for organising and describing your workspaces.
Finally, a couple of non-FabCon bits of content this week. Just Blindbæk has written an interesting blog about how to use and abuse the Semantic Model Scale-out feature to Reduce Refresh Memory on Large semantic model in Microsoft Fabric, by effectively clearing the model's data before re-hydrating it with your data. Elsewhere, Ben Gribaudo has shown a way to achieve Less GUIDs: Relative Current Workspace & Items By Name. If anyone has used a Dataflow Gen2 or Power Query to retrieve items from a Lakehouse, you'll benefit from Ben's trick highlighted in that article!
If you're interested in all things Microsoft Fabric, don't forget to sign up for our new newsletter Fabric Weekly. We'll be moving all Fabric content over from Azure Weekly in the near future. Don't worry - Power BI Weekly is remaining as-is, for the Power BI purists out there!
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) writes about Less GUIDs: Relative Current Workspace & Items By Name
- On the Fabric blog, Miguel Llopis (@mllopis) summarizes A wave of new Dataflow Gen2 capabilities at FabCon Atlanta 2026
🧩 Data Modeling
- On the Power BI blog, Sara Lammini Rodriguez announces TMDL View on the Web (Preview)
- Zoe Douglas (@MSPowerBI) shares some Semantic model tricks: Show when measures don't have a relationship to the column you are showing it by
- Gilbert Quevauvilliers (@GilbertQue) describes How to create a Power BI Semantic Model online (No need for PBI Desktop)
- On the Microsoft Fabric Café YouTube channel, Mehrdad Abdollahi hosts Calculation Group in Power BI Desktop and Fabric with Gbenga Adeyemo
- Chandeep Chhabra (@chandeep2786) describes The Gap Between Basic and Advanced Pivot Tables
📊 Report Authoring and Interactivity
- On the Power BI blog, Zoe Douglas (@MSPowerBI) provides a Deep Dive into Modern Visual Defaults and Customizing Theme Improvements (Preview)
- On the Power BI community blog, Parul Sagar (@parulsagar) shares From Normalized Tables to Business Insights: Using CONCATENATEX in Moodle Analytics
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) explains how to Prevent Future Date Spillage in Power BI Visuals
- Reid Havens (@HavensBI) talks about A Generated Report - How AI can make Dashboards (with Injae Park)
- Valerie Junk (@porcubi) shares Power BI Drill Down and Up Arrows Explained, New Visual Defaults Power BI March 2026 Update and Field Parameters in Power BI Explained – Switch Measures and Dimension
- Bas Dohmen (@HowToPowerBI) presents Copy This Goal Tracker in Power BI (File Included)
🚀 Deployment, Security and Operations
- Just Blindbæk (@justblindbaek) describes Implementing Semantic Model Scale-out to Reduce Refresh Memory in Microsoft Fabric
- On the Fabric blog, Leo Li shares the On-premises data gateway auto-update (admin triggered) (Generally Available)
- Also on the Fabric blog, Nadav Schachter describes how to Find and manage workspaces faster with workspace tags (Generally Available)
- On the Power BI Tips YouTube channel, Mike Carlo and Tommy Puglia (@PowerBITips) talk about Publish to Web vs. Embedded - Ep. 512 - Power BI tips
- Christopher Finlan (@cmfinlan) highlights Operationalizing the semantic model permissions update for Fabric data agents
🌐 General
- On the Power BI blog, Katie Murray (@MSPowerBI) shares the Power BI March 2026 Feature Summary
- On the BIFocal podcast, Jason Himmelstein (@jasehimm) covers Episode 320 – Power BI February 2026 Feature Summary
- On the Power BI blog, Mohammad Ali (@mohaali45) writes about Semantic Layers: The foundation of enterprise AI
- Eugene Meidinger (@sqlgene) writes about Can AI replace Power BI and Fabric experts?
- On the Power BI community blog, Sapna Gupta describes The Future of Business Intelligence: AI and Copilot in Power BI
- On the Power BI Tips YouTube channel, Mike Carlo and Tommy Puglia (@PowerBITips) discuss Scaling a Power BI Side Hustle - Ep. 511 - Power BI tips