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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.