Power BI Weekly Issue 221: 22nd August 2023
A jam-packed edition for some reason this week! To start, the Power BI August 2023 Feature Summary was released, including a new layout switcher to quickly toggle between desktop and mobile views, XMLA Write support for Direct Lake datasets and the ability to Choose a launch item for your Power BI mobile app. We've also been told about the significant improvement of the communication performance of XMLA-based tools, and there's an exciting new feature related to Dynamic subscriptions for paginated reports (Preview).
Elsewhere this week, I've continued my Microsoft Fabric E2E demo, this time talking about Local OneLake Tools. Finally, Štěpán Rešl has written an informative piece on Personal Workspaces in Times of Fabric, describing how they're just as useful as ever, but their governance is also just as important as ever. Do take a read!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Reid Havens (@HavensBI) shares 5 Pro Tips for Getting Started with Power Query and describes Leveling Up Power Query - Beyond the U/I with Chandeep Chhabra
- Chandeep Chhabra (@chandeep2786) explains how to Combine Data from Multiple Excel Files Most Dynamic Method Dynamic Columns & Sheets
- Purna (Chandoo) Duggirala (@r1c1) explains How to “auto” generate calendar tables with Power Query – The best method
- On the MSSQLTips site, Temidayo Omoniyi (@mssqltips) delves into Power BI Datamart Low-Code and No-Code Functionality to Streamline Reporting
- On Acuity Training, Ben Richardson (@AcuityTraining) describes how to Pivot and Unpivot Columns in Power BI and blogs about Power BI – Custom Columns
- Philipp Lenz (@lenz_philipp) explains how to Analyze Microsoft Azure DevOps Tags with Power BI
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes the Differences between GROUPBY and SUMMARIZE
- On the Power BI community blog, Andrei Khaidarov describes Calculating subtotals for the summary table using ROLLUPGROUP & SUMMARIZE
- Darren Gosbell (@darrengosbell) highlights v3.0.10 Release and v3.0.9 Release
- Sandeep Pawar (@PawarBI) shares a C# Script To Get A List Of Measures Matching Column Names
- Reid Havens (@HavensBI) talks about Simplifying DAX with Staging Tables & Relationships in Power BI
- On the Learning Science YouTube channel, Learning Science blogs about Filter data from fact table to dimension table using Power BI slicers
- Gregor Brunner presents about Measure Killer for Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Martin Schoombee (@MartinSchoombee) explains how to Create a calendar view with the matrix visual in Power BI
- Patrick Leblanc (@GuyInACube) describes Enabling Power BI Paginated Report Drill
- Adam Saxton (@GuyInACube) talks about Using Figma to wireframe your Power BI reports with Sekou Tyler and hosts Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (Aug 19, 2023)
- On the Data Bear blog, Althea Van Zyl lists the Top 10 Mistakes to Avoid in Power BI Reporting: A comprehensive overview of common pitfalls and errors in Power BI report creation and design.
- Meagan Longoria (@mmarie) shares a Quick Tip About Fonts in Deneb Visuals in Power BI
- On the MSSQLTips site, Harris Amjad (@mssqltips) describes How to Build a Custom Tornado Chart in Power BI Desktop
- Also on the MSSQLTips site, Kenneth A. Omorodion discusses Setting up Drill Through in the New Power BI Report User Interface
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) describes Transforming Power BI Customization: “WireFrames” in PowerBI.Tips Theme Generator
- Chandeep Chhabra (@chandeep2786) describes How to Create a Project Overlapping Timeline Dashboard in Power BI
- Andrzej Leszkiewicz (@avatorl) explains how to Want to Upgrade Your Power BI Matrix into an Advanced IBCS Style Data Visualization? Here's How!
- Bas Dohmen (@HowToPowerBI) writes about Automatically select KPIs based on the USER
- On the Power BI community blog, Sam Kumar (@inogic) blogs about Power BI Integration with Canvas App in Microsoft Dynamics 365 CRM
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, Maya Shenhav (@MSPowerBI) explains how to Choose a launch item for your Power BI mobile app
- Also on the Power BI blog, Kay Unkroth (@MSPowerBI) discusses Improving the communication performance of XMLA-based tools
- Also on the Power BI blog, Michael Bruhjell (@MSPowerBI) writes about Dynamic subscriptions for paginated reports (Preview)
- Chris Webb (@cwebb_bi) describes how to Log Out Of Power BI Automatically After A Period Of Inactivity
- Gilbert Quevauvilliers (@GilbertQue) discusses Power BI Query Usage and Performance Series – Part 1 – Enabling Log Analytics, generating the KQL queries
- On the Data Bear blog, Boniface Muchendu (@DataBearLTD) walks through Sharing Power BI Reports: Effective Tips for Success
- Marc Lelijveld (@MarcLelijveld) walks through Unveiling Tenant Configuration in Fabric: Empowering User Exploration
- Ignacio Barrau (@ignacho_07) writes about Integración con AzureDevOps Git Repos [Spanish]
- Štěpán Rešl (@tpnRel1) writes about Personal Workspaces in Times of Fabric
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 August 2023 Feature Summary
- Also on the Power BI blog, Arun Ulagaratchagan (@arunulag) writes Join us October 1-6, 2023, at the second annual Power Platform Conference in Las Vegas
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.