Power BI Weekly
Issue #276 - 19th September 2024
Welcome to the (belated) 276th edition of Power BI Weekly! Sorry for the delay for this edition - a combination of vacation and general busyness has pushed this edition back a few days. But it's hopefully going to have been worth the wait - there's a lot of great content this week. The one and only announcement this week is the On-premises data gateway September 2024 Release, which has the exciting update that the Fabric Pipeline integration is now GA (and therefore ready for your Production workloads!) Elsewhere this week, Marc Lelijveld has written a really handy blog around Purchasing Fabric Capacities as Reserved Instance (relevant for Power BI admins too) which may seem a little daunting for those new to this pricing model. Andre Fomin has performed an interesting comparison on Microsoft Fabric AI Skills vs. Copilot: Which GenAI Gives You the Best Answers?, trying similar queries on both tools to compare. And on a similar theme, Andrzej Leszkiewicz has demonstrated a custom AI Assistant for Tabular Editor to perform model-metadata tasks (such as adding comments to measures). Finally, Parul Sagar has reminded us of the potential power of Interactive Dialogue with Power BI’s Q&A Tool, showing some elements of how it can be fine-tuned (such as by adding synonyms).
🛠️ Data Prep
- On the RADACAD blog, Reza Rad (@RADACAD_COM) explains how to Migrate Power BI Dataflow Gen1 to Fabric Dataflow Gen2
- Chandeep Chhabra (@chandeep2786) describes How to Combine Multiple CSV Files into a Single Excel File
- Avi Singh (@powerbipro) discusses Power Query Self Merge in Power BI: Merge Table with Itself
- Kim Leblanc (@lecfomasque) writes Maîtrisez le 4e paramètre de Table.Group dans Power Query [French]
🧩 Data Modeling
- Reid Havens (@HavensBI) discusses Practical Use Cases for DAX Calculated Columns Tristan Malherbe
- Chandeep Chhabra (@chandeep2786) describes How to Filter by a Measure in Power BI - Yes, It's Possible
- On the Power BI community blog, hackcrr blogs about the Power BI Reporting Best Practices Analyzer
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) describes How to generate a random decimal number in Power BI DAX Random function in Power BI
- Sunil Mathew (@_sunil_mathew_) describes how to Highlight Min/Max Values Across Multiple Years Power BI Tutorial
- Andrzej Leszkiewicz (@avatorl) shares an AI Assistant for Tabular Editor
- Ignacio Barrau (@ignacho_07) writes about the [DAX] INFO functions
- Lars Schreiber (@SchreiberLars) writes So formatierst Du Deinen Gesamten DAX-Code auf einmal – Ganz ohne externe Tools [German]
- Parul Sagar (@parulsagar) writes about Enhancing Reports with Power BI Calculation Groups for User Segmentation
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) talks about Understanding Implicit and Explicit Measures in Power BI
📊 Report Authoring and Interactivity
- Marc Lelijveld (@MarcLelijveld) describes how to Sync two slicers without bi-directional relationships in Power BI
- Sunil Mathew (@_sunil_mathew_) shows a Custom Shape Map in Power BI
- Andre Fomin (@AndreFomin) presents Microsoft Fabric AI Skills vs. Copilot: Which GenAI Gives You the Best Answers?
- Parul Sagar (@parulsagar) describes Interactive Dialogue with Power BI’s Q&A Tool
🚀 Deployment, Security and Operations
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) shares the On-premises data gateway September 2024 Release
- Marc Lelijveld (@MarcLelijveld) describes Purchasing Fabric Capacities as Reserved Instance
- Chris Webb (@cwebb_bi) writes about Another Way To Get The SQL Generated By Power BI DirectQuery Mode
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) talks about Dynamic Row Level Security in Power BI with Many to many Best Practice
- Roland Szirmai (@BILAnalytics) describes How to Use Incremental Refresh for Lightning-Fast Power BI Dataflows | A Complete Guide
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) writes about Power BI Export to Excel
- Parul Sagar (@parulsagar) writes about Effective Row-Level Security: Case Studies from Education and Beyond