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