Power BI Weekly Issue 166: 19th July 2022
This month's Power BI Feature Summary includes announcements like the new NETWORKDAYS DAX function, the new Datamarts preview connector and that Error bars have gone GA. We've also had a couple of other official blogs this week, one of which is the announcement that Visualizing views in Dynamics 365 with Power BI is now generally available, and a blog explaining the differences between the relatively new ExecuteQueries REST API versus XMLA endpoints when programmatically retrieving query results.
Elsewhere this week, Meagan Longoria has outlined some Quality Checks for your Power BI Visuals, Chris Webb has pointed towards some guidance around Power BI DirectQuery Best Practices For Snowflake And Other Databases, and Harsh Joshi has described How To Calculate Ranking In A Hierarchical Form.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Ben Gribaudo (@bgribaudo) writes about An Error’s Expression Stack: A “Journal” of the Locations It Propagates Through
- Chris Webb (@cwebb_bi) describes Power BI DirectQuery Best Practices For Snowflake And Other Databases
- Gilbert Quevauvilliers (@GilbertQue) walks through Using an IN condition for multiple values in Power Query (Power BI)
- Ruth Pozuelo Martinez (@CurbalEN) covers Extract function in Power Query removes all the text? Here is how to fix it.
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) describes how to Sort Column Name in Power Query via M Code
- Chandeep Chhabra (@chandeep2786) walks through Getting Started with M in Power Query
- On the Learning Science YouTube channel, Learning Science explains how to Remove sub total or unwanted row from Dataset in Power BI using Power Query
- Ignacio Barrau (@ignacho_07) covers [PowerQuery] Tips para reducir pasos en editor de consultas [Spanish]
- Lars Schreiber (@SchreiberLars) covers So Verteilst du Monatswerte Linear auf Arbeitstage [German]
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains How To Install R Packages In Power BI and explains how to Create Power BI Report To SQL Server Using R Script
- Gaelim Holland (@_EnterpriseDNA) explains How To Avoid Errors When Integrating Python Scripts In Power BI
- On the Power BI community blog, Jie Zhao describes SAP General Ledger - Extract General Ledger Accounting Data to Power BI with Python Scripts
- On the SQL Server Central blog, Dennes Torres (@Dennes) describes Datamarts and exploratory analysis using Power BI
- On the SQL Data Partners podcast, Carlos L Chacon (@CarlosLChacon) presents Episode 249: Data Marts in Power BI
- Kim Leblanc covers Actualiser une connexion à une API sur Power BI Service [French]
- On the Power BI community blog, Eyelyn Qin describes how to Define a temporary function or multiple variables in a single column
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes How to Connect to an Analysis Services Database in Power BI
- Mara Pereira (@datapears) writes about Where to find sample data online
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the endjin blog, Jessica Hill (@JessRoseHill_) discusses Context Transition in DAX
- Also on the SQLBI blog, Marco Russo (@marcorus) covers The Filter Context - The Whiteboard #01
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes EVALUATE, ORDER BY – DAX Guide
- James Andrew (@MatadorSoftware) describes how to Use DAX to Calculate Running Totals in Power BI
- Harsh Joshi (@_EnterpriseDNA) explains How To Calculate Ranking In A Hierarchical Form
- Bernat Agulló Roselló (@AgulloBernat) describes Data Validation with Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Reid Havens (@HavensBI) explains how to Create a Multi-Selection Drillthrough Button in Power BI
- Roland Szirmai (@BILAnalytics) covers Field Parameters Using Measures
- Bas Dohmen (@HowToPowerBI) describes Measure-Driven Data Labels in Power BI and talks about Pimp My Slicer | Improving the Design of Native Slicers in Power BI - Step by Step
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) covers Analyzing spatial data with Azure Maps in Power BI
- James Andrew (@MatadorSoftware) explains how to Create High Quality Animated Backgrounds in Power BI
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) blogs about Messages explaining visuals - Overlap technique
- Meagan Longoria (@mmarie) writes about Quality Checks for your Power BI Visuals
- Reid Havens (@HavensBI) covers Quality Checks on Your Power BI Reports (with Meagan Longoria)
- Leila Gharani (@LeilaGharani) describes how to Properly Present Your Power BI Dashboard in PowerPoint (Keep the Interactivity)
- On the Perficient blog, Seema Borhade (@Perficient) describes How to Create and Use Paginated Reports in Power BI
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, Kay Unkroth discusses ExecuteQueries REST API versus XMLA endpoints at scale
- Adam Saxton (@GuyInACube) talks about Is it a known issue in Power BI?
- Bernat Agulló Roselló (@AgulloBernat) covers Controlling Calculation Items with RLS
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) describes Embedding a Stream video in Power BI service
- Philipp Lenz (@lenz_philipp) describes how to Setup Purview to get Metadata from Power BI
- On the Perficient blog, Shubham Kapse (@Perficient) explains How to Implement Row Level Security in Power BI- Static RLS
- On the Blue Granite blog, the BlueGranite team (@BlueGraniteInc) discusses Automating Your Power BI Refresh History
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, Oksana Kyrychenko (@MSPowerBI) announces Power BI July 2022 Feature Summary
- On the Power BI blog, Amanda Rivera (@MissAmandaN) announces that Visualizing views in Dynamics 365 with Power BI is now generally available
- Sam McKay (@_EnterpriseDNA) discusses Business Intelligence as a Service Solution with Erik Svensen
- Neil Hambly (@Neil_Hambly) talks about Power BI in Synapse Analytics
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.