Power BI Weekly Issue 178: 11th October 2022
Just the one announcement this week, which is about Deployment pipelines – announcing "Deployment History" feature and "Azure DevOps extension" GA. Elsewhere this week, James Broome has written another element of the Insight Discovery series, with Part 5 - Deliver insights incrementally with data pipelines, Gavin Pedersen has described Power BI Workspace Strategy for Self Service within Premium Capacities, and Andrzej Leszkiewicz has given us a bit of fun with Power BI Pacman.
Finally, I'm excited to share that my colleague Ian Griffiths and I are running a free 1-day, in-person workshop about creating a modern data lake (house) architecture with full DevOps on Azure Synapse Analytics in London (UK) on Wednesday Nov 2nd 2022. This is an in-person (not virtual) event. Full workshop agenda can be found here and to register your interest use this form. Spaces are limited, so register quickly!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) explains How to connect to a Power BI Datamart in Power BI Desktop
- Kevin Chant (@kevchant) writes about GitHub Actions information using the GitHub connector in Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes Power BI Real-time Streaming Dataset
- On the Tessellation Tech blog, Manikanta Gudivaka explains How to Load Large Datasets in Power BI Desktop Using Parameters
- Melissa de Korte (@_EnterpriseDNA) explains How To Use COALESCE In Power Query / M
- Adam Saxton (@GuyInACube) describes A Power Query feature you may not know about
- Jarrett Moore (@BuckeyeJarrett) describes How To Reference Tables In Power Query For Improved Refresh Time & Data Performance
- Dan English (@denglishbi) writes about Power BI using Synapse Serverless Pool with Delta Lake format
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Also on the SQLBI blog, Marco Russo (@marcorus) discusses Storage Engine (VertiPaq) – The Whiteboard #07
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses SELECTEDMEASURE – DAX Guide
- Philipp Lenz (@lenz_philipp) blogs about Power BI composite models – a underestimated feature
- Sam McKay (@_EnterpriseDNA) describes 'What If' Sensitivity Analysis In Power BI Using DAX - Advanced Technique [2022 Update]
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about DAX Query Example Using Various Keywords & Functions
- On the Learning Science YouTube channel, Learning Science describes 3 ways to add calculated or custom column in Power BI
- Matt Allington (@ExceleratorBI) covers Measure Killer for Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes A Single Measure for Formatting and Button Navigation
- Bas Dohmen (@HowToPowerBI) describes how to Highlight Chosen Data Points in a Line Chart
- On the Foresight BI blog, Ahmed Oyelowo (@AhmedOyelowo) explains how to Hide Total For Selected Column In Power BI Table
- Reid Havens (@HavensBI) discusses Creating a Win/Loss Spark Chart in Power BI and talks about Alternative Ways to Drillthrough with Hyperlinks
- Also on the Power BI community blog, Kumail Raza writes about Custom Visuals in Power BI
- On the Enterprise DNA blog, Gustaw Dudek (@EnterpriseDNA_) describes Dashboard Layout Design Techniques
- Andrzej Leszkiewicz (@avatorl) shares Power BI Pacman
- James Andrew (@MatadorSoftware) provides A Bumper Guide to Using Python in Power BI | Importing Data, Transformations, Python Data Viz & More
- Kelly Kaye (@MS_KellyKaye) presents Power BI Community Show Ep 10 - Amit Chandak
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, Lee Benjamin writes about Deployment pipelines – announcing "Deployment History" feature and "Azure DevOps extension" GA
- Chris Webb (@cwebb_bi) walks through Monitoring Power BI Desktop Activity Using Extended Events In SQL Server Management Studio
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 26: Modern React-JS Development with App-Owns-Data Embedding
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Incremental Refresh and Hybrid tables in Power BI: Load Changes Only
- On the Tessellation Tech blog, Gavin Pedersen (@gavin_PD) covers Power BI Workspace Strategy for Self Service within Premium Capacities
- Reid Havens (@HavensBI) walks through Sharing Power BI Content with Multiple Audiences (with Tom Martens)
- Pat Mahoney (@mahoneypa) explains how to Get Notified on Successful Power BI Dataset Refresh
- Bernat Agulló (@AgulloBernat) describes Writing Tabular Editor C# Scripts like a Boss
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the MSSQLTips site, Daniel Calbimonte (@dcalbimonte) provides a Power BI Certification FAQ for Exams PL-300 and PL-900
- Brian Julius (@_EnterpriseDNA) announces Microsoft PL-300 Certification - New Course
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.