Power BI Weekly
Issue #250 - 19th March 2024
SQLBits is upon us - I hope a good number of you have been fortunate enough to attend this year. If anyone reading this is attending, I'll be here all week, so please come and say hi.
Outside SQLBits, there's been a pretty significant announcement this week in the Power BI space, and that's the Upcoming Retirement of Power BI Premium P SKUs (for everyone apart from sovereign cloud customers). I can't say this is a huge surprise (what with the new Fabric SKUs) but it's something you should start planning for sooner rather than later.
Some other announcements this week include the On-premises data gateway March 2024 release, in which we've been told about the Service Principal (SPN) support for on-premises and VNET data gateways. We've also been given some Copilot Updates March 2024, containing some admin updates and the announcement of added support for Apps, allowing report consumers to interact with Copilot as they browse app artifacts.
Sticking on the Copilot theme, Chris Webb has written a helpful blog discussing How Much Does Copilot Cost In Microsoft Fabric?, pointing out how that's not actually the right question to ask. Alberto Ferrari has written the first SQLBI blog on visual calculations, introducing VISUAL SHAPE for visual calculations in Power BI. Finally, my colleague Paul has written a brilliant in-depth blog about How to Build Visually Appealing and User Friendly Navigation into Power BI.
🛠️ Data Prep
- Adam Saxton (@GuyInACube) explains how Include in Refresh can trip you up within Power Query
- On the Learning Science YouTube channel, Learning Science explains How to merge multiple sheets into one while loading data in Power Query using Excel or Power BI?
- On the RADACAD blog, Reza Rad (@Rad_Reza) delves into Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Introducing VISUAL SHAPE for visual calculations in Power BI
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes [DAX] Time Intelligence vs WINDOW vs OFFSET
- On Acuity Training, Maximillian Hindley writes about 6 Best Practices for Efficient Data Modeling in Power BI
- Chandeep Chhabra (@chandeep2786) describes How to Create One to Many Relationship in Power BI
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) describes How to generate Business Friendly Power BI Data Dictionary using Open AI Semantic Link
- On the Power BI community blog, Yifan Wang describes how to Display data in a fixed order and show data for the top three selections
📊 Report Authoring and Interactivity
- Reid Havens (@HavensBI) describes Dynamic Column Headers (with Field Parameters) in Power BI
- On the endjin blog, Paul Waller (@Crashbangwaller) explains How to Build Navigation into Power BI
- On the Learning Science YouTube channel, Learning Science explains how to Calculate a running sum or running total at visual level without using DAX measures in Power BI
- Binbin Yu covers Dynamic filtering of two tables based on one slicer
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) explains How to Sync Slicers in Power BI
- On Acuity Training, Ben Richardson (@AcuityTraining) covers Decomposition Tree Visuals – Quick Guide
- Oscar Martínez Valero (@OValerock) talks about Rethinking Dashboard Design
- Nidhi Srinath (@TDataScience) covers Creating Interactive Power BI Dashboards That Engage Your Audience
- Nidhi Srinath (@TDataScience) describes Creating Interactive Power BI Dashboards That Engage Your Audience
- Ben Richardson (@AcuityTraining) writes about the Decomposition Tree Visuals - Quick Guide
🚀 Deployment, Security and Operations
- On the Power BI blog, Kim Manis (@kimmanis) announces Important update coming to Power BI Premium licensing
- Also on the Power BI blog, Nikki Waghani (@NikkiWaghani) shares the On-premises data gateway March 2024 release
- Chris Webb (@cwebb_bi) writes about How Much Does Copilot Cost In Microsoft Fabric?
- Mihály Kávási (@KavasiM) explains How to find which visual generated the query in Log Analytics?
- Marcus Wegener (@PowerBIler) covers Power BI Verwendungsszenario – Unternehmens-BI [German]
- Soheil Bakhshi (@biinsightnz) discusses Microsoft Fabric: Source Control Options for Power BI Developers
- Pat Mahoney (@mahoneypa) discusses Power BI Semantic Model Snapshots With A Fabric Notebook
- Kevin Arnold (@kevarnold) shares some Scripts to improve copying a Direct Lake semantic model to another workspace using Microsoft Fabric Git integration locally
🌐 General
- On the Power BI blog, Mohammad Ali (@mohaali45) shares Copilot Updates March 2024
- Chandeep Chhabra (@chandeep2786) talks about My Top 5 Power BI Mistakes (and how to avoid them)
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) discusses Power BI Tutorial for Excel Users
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 273 - Interview with Alex Powers
- Matt Allington (@ExceleratorBI) presents My Latest Podcast with Rob Collie from P3 Adaptive