Power BI Weekly
Issue #309 - 27th May 2025
A couple of updates this week, which are the Power BI Report Server May 2025 Feature Summary (including a small set of updates from the March Power BI Desktop release) and the On-premises data gateway May 2025 release. On the community side this week, we have a number of interesting articles. Firstly, Ben Gribaudo has made us (or at least me) aware of Power Query's default rounding behaviour, which differs to the high-school rounding most of us will have learned. Philipp Lenz has shown how to create and retrieve Descriptions of key performance indicators/measures and how to visualize/display them in reports. Teo Lachev has written about the good, bad and the ugly in the article First Look at Fabric Translytical Task Flows. Finally, Dan English has written a blog highlighting a small feature from the latest feature summary that may have gone unnoticed, and that's the ability to Paste List of Values into Slicer. So you can now copy some values from Excel and paste them straight into the new List and Button slicers!
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) writes about Rounding: Power Query vs. Others
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) blogs about Working with Merged Cells from Excel in Power BI using Power Query Fill Down Transformation
- Rick de Groot (@Rickmaurinus) describes AI + Power Query (Ep. 1): Fix Messy Identifiers in Your M Code and talks about AI + Power Query (Ep. 2): Turn Table Images into M Code with AI
- Chris Webb (@cwebb_bi) blogs about Generating Sample Data With Copilot In Fabric Dataflows Gen2
🧩 Data Modeling
- On the Power BI community blog, mohsinr12 writes about Comparing Semantic Modelling Options in Fabric
- Reid Havens (@HavensBI) talks about Using Paired Columns in Power BI Field Parameters for Accurate Grouping
- Chandeep Chhabra (@chandeep2786) tells us to Stop Making These DAX Mistakes in Power BI
- Dhruvin Shah (@DhruvinShah16) discusses DAX Measures in Power BI | Episode 09 | Power BI Beginner Tutorial Series
- Also on the Power BI community blog, Anmol Malviya explains How to Create Multiple Measures at Once Using TMDL View in Power BI Desktop and writes about Power BI TMDL View: Create a Time Intelligence Calculation Group in Just One Click
- Philipp Lenz (@lenz_philipp) blogs about Description of key performance indicators/measures and how to visualize/display them in reports
📊 Report Authoring and Interactivity
- Dan English (@denglishbi) discusses Power BI – Paste List of Values into Slicer
- Bernat Agulló Roselló (@AgulloBernat) shares Two new C# Scripts for PBIR: Replace Fields & Open Visual Json Files
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) talks about the Power BI Mobile Layout Auto Create
- Dhruvin Shah (@DhruvinShah16) shares Power BI Visual Makeover | Episode 10 | Power BI Beginner Tutorial Series, Power BI Theme Masterclass | Episode 11 | Power BI Beginner Tutorial Series, Custom Visual in Power BI | Episode 12 | Power BI Beginner Tutorial Series and Bookmark in Power BI | Episode 13 | Power BI Beginner Tutorial Series
- On the Prologika blog, Teo Lachev (@tlachev) writes about First Look at Fabric Translytical Task Flows
- On the Power BI community blog, Tharun Kumar Ravikrindhi writes about One Power BI Report, Multiple Default Views
🚀 Deployment, Security and Operations
- On the Fabric blog, Leo Li shares the On-premises data gateway May 2025 release
- On the Microsoft Fabric Café YouTube channel, Mehrdad Abdollahi presents Jon Vöge - Learn to Create 3 Types of Low-Code Power BI & Microsoft Fabric Extensions with Power Apps
- Sunil Mathew (@_sunil_mathew_) walks through PBI Security | Dynamic RLS + Personalized Greeting
- Valerie Junk (@porcubi) describes how to Monitor Report Usage in Power BI and talks about the Performance Analyzer in Power BI