Power BI Weekly
Issue #198 - 14th March 2023
A few more announcements this week. Possibly the most exciting of the announcements is the (opt-in) public preview of On-object, a new and improved way to format visuals within Power BI, allowing you to edit granular elements of a visual by selecting the items on the visual itself. We've also been told that The Scanner API now includes even more metadata, such as scheduled refresh settings, RDL, RLS configuration, and more, that you can now Use Power BI data from different regions in your Power Apps solution and that the ApproximateDistinctCount DAX Function Now Works On More DirectQuery Sources.
Elsewhere this week, Adam Saxton has spoken about Dataset permissions required for App report in Power BI? What am I missing? (particularly regarding shared datasets), and Harris Amjad has walked-through How to Create a Sunburst Chart in Power BI Desktop - an interesting way to visualize hierarchical data.
🛠️ Data Prep
- Pat Mahoney (@mahoneypa) covers Removing a variable number of first rows in Power Query
🧩 Data Modeling
- Chris Webb (@cwebb_bi) blogs about ApproximateDistinctCount DAX Function Now Works On More DirectQuery Sources
- On the SQLBI blog, Marco Russo (@marcorus) discusses DAX Studio Timeline in Server Timings – Unplugged #49
- Sam McKay (@_EnterpriseDNA) talks about Creating Dynamic Outlier Trigger Points - Advanced Power BI Analysis Technique [2023] and explains How To Create Tables By Combining UNION and ROW Functions In Power BI [2023 Update]
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe Power BI P&L Statements: Challenges And Solutions
- Kim Leblanc covers Power BI vous suggère des mesures en langage DAX [French]
- Ignacio Barrau (@ignacho_07) covers [TabularEditor] Documentar automaticamente descripciones de Medidas [Spanish]
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe how to Format String Calculation Groups In Power BI P&L Statements
📊 Report Authoring and Interactivity
- On the Power BI blog, Roseanne Levasseur talks about On-object | Public Preview (Opt-in)
- Matthew Roche (@SQLAllFather) writes about Power BI and PowerPoint integration – “Storytelling” is now generally available
- David Abu (@DavidAbu_) describes Power BI and Power Point working together
- Matt Allington (@ExceleratorBI) writes about PowerPoint Integration with Power BI Visuals
- Reid Havens (@HavensBI) talks about Custom Image Dimensions for Matrix/Table Visuals in Power BI and walks-through New Way to Apply Conditional Formatting by Category in Power BI
- Brian Julius (@_EnterpriseDNA) covers How To Use Conditional Formatting Based On String Fields - Power BI February 2023 Updates and lists the Top 10 Power BI Drill Though Pro Tips
- On the Power BI community blog, Nandu Krishna (@NanduKrishnaVS) writes about Conditional formatting in the scatter chart based on a trend line value
- On the MSSQLTips site, Harris Amjad (@mssqltips) describes How to Create a Sunburst Chart in Power BI Desktop
- Pat Mahoney (@mahoneypa) provides an Intro To Low Code Custom Visuals in Power BI
- On the Learning Science YouTube channel, Learning Science describes how to Sync two different slicers from different tables without a relationship in Power BI
- Lars Schreiber (@SchreiberLars) covers So kannst du viele measures mit nur einem klick in Power BI per datenschnitt wechseln [German]
- Greg Philps (@_EnterpriseDNA) describes How To Create Deneb IBCS-style Performance Visual In Power BI
- Mohammed Adnan talks about Paginated Reports Context & Data Region - GPPB 2023
- Davide Bacci has demonstrated a Sankey Chart using Deneb
🚀 Deployment, Security and Operations
- On the Power BI blog, Paul Inbar (@MSPowerBI) announces The Scanner API now includes even more metadata, such as scheduled refresh settings, RDL, RLS configuration, and more
- Also on the Power BI blog, Maya Movshovitz announces Use Power BI data from different regions in your Power Apps solution
- Just Blindbæk (@justblindbaek) covers Extension to the Scanner API
- Matthew Roche (@SQLAllFather) writes that The Power BI Scanner API keeps getting better
- On the Enterprise DNA blog, Greg Deckler (@GregDeckler) writes about Power BI Roles And Licenses For Your Projects
- Adam Saxton (@GuyInACube) talks about Dataset permissions required for App report in Power BI? What am I missing?
- Antriksh Sharma (@AntrikshShar) explains how to Add or Remove a User or Group from all Workspaces in Power BI Service
- Bernat Agulló Roselló (@AgulloBernat) covers Rethinking Security Groups for Power BI
- Also on the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes how to Structure A Power BI Deployment Through A Teams Perspective
- Reid Havens (@HavensBI) talks about Report/Dataset Lifecycle Management for Power BI (with Greg Baldini)