Power BI Weekly
Issue #304 - 22nd April 2025
Probably more interesting news to this readership is the Power BI April 2025 Feature Summary. It's (unsurprisingly) quite a light one this month, but here are some highlights: there's now Ad hoc calculation support for data questions now available in read mode for Copilot, the Mobile layout auto-create functionality is now GA, and there are some model-layout-related updates to the Live edit of semantic models in Direct Lake mode with Power BI Desktop Preview feature. And on that last point, Zoe Douglas has provided a Deep dive into Direct Lake on OneLake and creating Direct Lake semantic models in Power BI Desktop for those that want to explore deeper.
Finally, I'd like to highlight that I'll be presenting the talk Microsoft Fabric: Too Many Options - Which One(s) Should I Choose? at the Oxford Microsoft Data Platform Group on 7th May (both online and in-person). There's "choice-overload" in Fabric - so I'll be implementing the same underlying data pipeline using different Microsoft Fabric item types and comparing and contrasting them for you. Would love to see you there (either physically or virtually!)
🛠️ Data Prep
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) talks about Power BI Get Data from SharePoint Folder using Power Query and covers SharePoint Files or Folder Contents in Power BI using Power Query
- Dhruvin Shah (@DhruvinShah16) describes how to Load Data from Different Sources in Power BI | Episode 02 Power BI Beginner Series
- Rick de Groot (@Rickmaurinus) talks about Combining Tables and keep context in Power Query M (Table.FromPartitions trick!)
- Lars Schreiber (@SchreiberLars) writes Datum in Power Query verschieben – nur Werktage zählen! [German]
🧩 Data Modeling
- Chris Webb (@cwebb_bi) talks about the Memory Overhead Of Distinct Count Measures In Power BI
- On the SQLBI blog, Marco Russo (@marcorus) writes about Dynamic Pareto analysis in Power BI
- On the Purple Frog Systems blog, Tom Owen (@PurpleFrogSys) describes Replacing Nested IFs with SWITCH functions in DAX
- Valerie Junk (@porcubi) talks about Variables in Power BI
- Chandeep Chhabra (@chandeep2786) walks through 5 Powerful Data Modelling Practices
📊 Report Authoring and Interactivity
- On the Power BI blog, Zoe Douglas (@MSPowerBI) shares a Deep dive into Direct Lake on OneLake and creating Direct Lake semantic models in Power BI Desktop
- On the Power BI community blog, Anmol Malviya delves into Creating a Custom Tooltip in Power BI and describes How to Stop Filtering in Some Visualizations in Power BI
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) talks about the Free Text Slicer for searching text values in Power BI | New text slicer in Power BI
- Eugene Meidinger (@sqlgene) presents Ep. 12 - Power BI, Data Viz, and Solving the Right Problem (with T. from Data Rocks)
- Reid Havens (@HavensBI) describes Bookmarks + Field Parameters Better Hierarchy Controls
- Valerie Junk (@porcubi) discusses Power BI Page View - Fit to page - No more scrollbars and describes how to Change the background color in Power BI
- Also on the Power BI community blog, Tharun Kumar Ravikrindhi writes that This One Matrix Setting Can Kill Your Power BI Report Performance
- Parul Sagar (@parulsagar) shares Telling Data Stories with Enhanced Card Visuals in Power BI and describes Enhancing PowerPoint Presentations with Power BI Annotations
🚀 Deployment, Security and Operations
- On the Fabric blog, Leo Li highlights the On-premises data gateway April 2025 release
- On the Power BI community blog, Chinmaya Patra, Pradip VS and Vivienne Vereen share Dynamic Row-Level Security (RLS) Implementation in Power BI (Part 2)
- Dániel Gábor Patkós shares Building your Power BI CI/CD pipeline with GitHub Actions (Part 1)
- Gilbert Quevauvilliers (@GilbertQue) describes How to Rebind a Power BI Report to a different Semantic Model using Power BI Studio
- On the MSSQLTips site, Jared Westover (@WestoverJared) describes SQL Export to Excel via Power BI XMLA
🌐 General
- On the Power BI blog, Kim Manis (@kimmanis) writes that Microsoft named a Leader in The Forrester Wave: Business Intelligence Platforms, Q2 2025 and writes Watch the FabCon Las Vegas keynote recording now!
- On the Power BI blog, Patrick LeBlanc (@GuyInACube) shares the Power BI April 2025 Feature Summary
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 291 - Power BI March 2025 Feature Summary
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) talks about Power BI Mistakes to Avoid – Part 2
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shares a Data Storytelling Dashboard in POWER BI | Statement of Comprehensive Income | IBCS (ZEBRA BI Visual)