Power BI Weekly Newsletter Issue #198

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

• Pat Mahoney (@mahoneypa) covers Removing a variable number of first rows in Power Query

Data Modeling

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

• 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

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

• 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

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

• 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)

General

Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs

• No content this week

Useful Links

• 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