Power BI Weekly
Issue #225 - 19th September 2023
It's monthly updates galore at the moment, with the introduction of Fabric updates running parallel to the usual Power BI updates. I think it's fair to say the volume of Power BI-specific updates has taken a bit of a hit, with the September 2023 Feature Summary being relatively short compared to those of old. Most useful announcements (IMHO) are that the mobile editing canvas is now interactive and that there have been some Row-level security test as role improvements. Elsewhere this week, Tom Martens has written a detailed article describing How I write complex DAX statements, and Bas Dohmen has showcased another bit of visual mastery in the video UX Revolution with Visual Level Pagination in Power BI.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) writes about Multiple Connections To The Same Data Source In The Power BI Service With Shareable Cloud Connections
- On the phData blog, Gavin Pedersen (@gavin_PD) explains How to Create a Snowflake Connection for a Power BI Gateway
- Chandeep Chhabra (@chandeep2786) describes The Magic of Records in Power Query || Display Advanced Calculations Step-by-Step and share a Useful Power Query Trick || Quickly Go to Any Column
- Reid Havens (@HavensBI) describes Extracting SQL Database/Table Names From Your Power BI Dataset
- Max Wikström (@maxwiks) discusses Mastering DirectQuery in Power BI: A Deep Dive into Performance Optimization – Part 1
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) walks through Using DAX to control a chart range in Power BI
- On the Purple Frog Systems blog, James Snow (@PurpleFrogSys) covers Power BI: Grouping & Binning using Data Groups
- Tom Martens (@tommartens68) shares DAX from the trenches - how I write complex DAX statements
📊 Report Authoring and Interactivity
- Bas Dohmen (@HowToPowerBI) explains how to Get more out of your bar charts in Power BI and shares a UX Revolution with Visual Level Pagination in Power BI
- On the Learning Science YouTube channel, Learning Science explains How to Create Paginated Report in Power BI Service? | Paginated Report in Power BI
🚀 Deployment, Security and Operations
- On the phData blog, Gavin Pedersen (@gavin_PD) writes about How and When to Use Power BI Row-Level Security
- Prathy Kamasani (@pkamasani) describes how to Document Power BI Workspaces with Microsoft Fabric Notebooks
- Marc Lelijveld (@MarcLelijveld) explains how to Add service principal to Fabric workspace using Power BI REST API
- On the Power BI community blog, Sam Kumar (@inogic) describes How To Filter Activities by Selected Users in Power BI Reports?
🌐 General
- On the Power BI blog, Ryan Majidimehr (@MSPowerBI) shares the Power BI September 2023 Feature Summary
- Elayne Jones explains how to Become a Data Wizard Using Generative AI with Power BI