Power BI Weekly Issue 213: 27th June 2023
Yet another positive outcome for Microsoft in the Forrester Wave™ analysis for Augmented BI Platforms, Q2 2023, where Microsoft has been named a Leader (unsurprisingly). Yet again, well done to the Power BI Fabric team and the wider Microsoft data teams for this achievement! As for more "normal" announcements, we've been told about the new, additional Multitasking improvements for Power BI in Microsoft Teams, with some smarter caching mechanisms to allow you to pick up where you left off much more easily. And we've been told about the On-premises data gateway June 2023 release, which adds support for Fabric Lakehouse connectivity over the gateway, and highlights that the 'EnableWebView2' flag is now opt-out - pay attention for those of you who have yet to make the switch.
Elsewhere this week, Zoe Douglas has joined Patrick Leblanc to Dig into dynamic format strings for DAX measures in Power BI, and Bernat Agulló is back with a helpful blog about how to Sort a Matrix by a Calculation Item Column.
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)
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.