Power BI Weekly Newsletter Issue #213

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sibling newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

• Adam Saxton and Justyna Lucznik (@GuyInACube) talk about Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)
• On the Access Analytic blog, Wyn Hopkins (@wynhopkins) blogs about Streamlining Power Query Code Documentation with GPT-4: A Game Changer

Data Modeling

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) introduces the RANK window function in DAX
• Patrick Leblanc and Zoe Douglas (@GuyInACube) dig into dynamic format strings for DAX measures in Power BI
• Chandeep Chhabra (@chandeep2786) describes How to Model Price Increase in Power BI | Data Modeling Case Study
• On the Purple Frog Systems blog, Tom Owen (@PurpleFrogSys) describes how to Power BI – Recalculate / Refresh a Calculation Group
• On the Learning Science YouTube channel, Learning Science discusses Are unconnected tables allowed in Power BI data model?
• ,, Bernat Agulló (@AgulloBernat) describes Sorting a Matrix by a Calculation Item Column

Report Authoring and Interactivity

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

• Reid Havens (@HavensBI) talks about New (And Improved) Native Card Visual for Power BI
• Leila Etaati (@leila_etaati) covers New Card Visual: Add Images to the Card Visual
• Bas Dohmen (@HowToPowerBI) describes how to Apply all slicers in Power BI, explains how to Hide apply all slicers button when nothing is selected, describes how to Clear all slicers in Power BI and talks about Finally custom labels arrived in Power BI
• On the Power BI community blog, Inogic (@inogic) writes Exploring Bookmarks in the OOB Power BI service reports
• Sam McKay (@_EnterpriseDNA) describes how to Supercharge Your Power BI Workflow: A Guide to Using ChatGPT
• On the Learning Science YouTube channel, Learning Science explains how to Learn Power BI on your own with the help of ChatGPT step by step guide

Deployment, Security and Operations

Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling

• On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces Even more Multitasking improvements for Power BI in Microsoft Teams
• On the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway June 2023 release
• Marcus Wegener (@PowerBIler) describes How to use multiple Power BI Desktop profiles and covers Wie man mehrere Power BI Desktop-Profile verwendet [German]
• Just Blindbæk (@justblindbaek) describes how to Extract and query the tenant settings
• Chris Webb (@cwebb_bi) shares Power BI Monitoring Video
• On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) explains how to Develop and test RLS Rules in Power BI
• On the Power BI community blog, Inogic (@inogic) explain how to Add Power BI Reports On Model-Driven App Form with Power BI Report Control
• Bernat Agulló Roselló (@AgulloBernat) walks through Helping users find Power BI Apps

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, Kim Manis (@kimmanis) announces Microsoft named a Leader in The Forrester Wave™: Augmented BI Platforms, Q2 2023
• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 260 - Power BI June 2023 Feature Summary
• The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 231
• Peter Myers (@MSPowerBI) talks about Power BI Paginated Reports in a Day - 27: March 2023 Update
• Reid Havens (@HavensBI) talks about The Data Dojo: A Power BI Community of Practice (with James Bartlett)

Useful Links

• Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more