Power BI Weekly
Issue #275 - 10th September 2024
Welcome to the 275th edition of Power BI Weekly! This week we've been told about the new TMDL support for the ALM Toolkit, bringing a rich diff experience and deployment functionality on models using the TMDL format. Elsewhere this week, Jess Hill has followed up with the second in her blog series, explaining Why Power BI developers should care about the Power BI enhanced report format (PBIR) (to add to her first about the PBIP format), Kurt Buhler has written a detailed blog titled Myths, Magic, and Copilot for Power BI, and Jon Stjernegaard Vöge has written a step-by-step guide about How to share Fabric / Power BI Semantic Models with External Users.
🛠️ Data Prep
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) talks about Duplicate VS Reference in Power Query in Power BI and Fabric Dataflows and and Power Query Basics of M Scripting in Power BI and Fabric
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) describes How to remove special characters from a text column in Power Query?
- Gilbert Quevauvilliers (@GilbertQue) writes Did you know external Guest users can connect to your Semantic Model using Excel
- Rick de Groot (@Rickmaurinus) writes Understanding Semi Joins in Power Query M
- Shivanshu Bisht describes Wildcard Filtering by PQ + DAX or Custom Visual
🧩 Data Modeling
- On the RADACAD blog, Reza Rad (@RADACAD_COM) discusses REFRAME in Power BI Direct Lake
- Chris Webb (@cwebb_bi) explores Advanced Relationship Properties In Power BI Copilot
- On the Business Intelligist blog, Andre Fomin (@AndreFomin) talks about DAX for Time Series Forecasting in Power BI
- Darren Gosbell (@darrengosbell) highlights the DAX Studio v3.2.1 Release
- Adam Saxton (@GuyInACube) covers The Surprising Enhancements for DAX Query View in Power BI with Zoe Douglas
- Laura Graham-Brown (@Laura_GB) talks about a DevOps Parent Child Hierarchy in Power BI
- Reid Havens (@HavensBI) hosts Awesome Use-Cases with DAX Query View with Zoe Douglas
- Jon Stjernegaard Vöge writes about Mastering Power BI Hierarchies: Conditional Drill Through and returning values only for specific hierarchy levels
📊 Report Authoring and Interactivity
- On the endjin blog, Jessica Hill (@JessRoseHill_) writes about Why Power BI developers should care about the Power BI enhanced report format (PBIR)
- On the SQLBI blog, Marco Russo (@marcorus) covers Context transition in DAX explained visually
- Bas Dohmen (@HowToPowerBI) describes A Game-Changer for Map Visuals in Power BI Distance Filtering
- Sunil Mathew (@_sunil_mathew_) explains how to Build an Interactive Sales Dashboard in Power BI and describes how to Highlight Min/Max Values Across Multiple Years
- Kurt Buhler (@kurtbuhler) covers Myths, Magic, and Copilot for Power BI
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) covers Timesaving Tips to Create Polished Power BI Reports by Allison Kennedy Auckland Power BI & Fabric
- Roland Szirmai (@BILAnalytics) explains how to Transform Your Power BI Reports with Conditional Slicers
🚀 Deployment, Security and Operations
- Nandan Hegde (@nandan_hegde15) shares an Automated Way for PBIX to PBIP file Conversion
- Jon Stjernegaard Vöge describes How to share Fabric / Power BI Semantic Models with External Users, describes Exploring the new Dynamic Subscriptions for Power BI Reports and writes about Row Level Security in Microsoft Fabric — Update: No need for Tabular Editor!
🌐 General
- On the Power BI blog, Sid Vemuri announces TMDL support for the ALM Toolkit