Power BI Weekly
Issue #188 - 3rd January 2023
Welcome to the 188th edition of Power BI Weekly, and the first of 2023! Hope you're feeling refreshed and ready for the new year. As you can imagine, there's been no official announcements over the festive period. So, I'll highlight a few blogs: Jeffrey Wang has published part two in the Introducing DAX Window Functions series deeping diver into performance characteristics, Alexandru Badiu has described how to create a Power BI User Guide In Your Reports to help users get up to speed with interacting with your report, and Marc Lelijveld has written an in-depth blog about Migrating to Power BI, but how?
🛠️ Data Prep
- On the Learning Science YouTube channel, Learning Science describes Complex Dataset Cleaning in Power Query Using Power BI
- Imke Feldmann (@TheBIccountant) shares a Present Value (PV) function for Power Query and a Future Value function (FV) for Power Query
- Chandeep Chhabra (@chandeep2786) talks about The Magic of working with Records in Power Query
- Ben Gribaudo (@bgribaudo) describes Power Query M Primer (Part 25): Extending the Global Environment and shares M Language Specification in Review: 2022
- Lars Schreiber (@SchreiberLars) covers Sind meine Power BI-Daten aktuell? [German]
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) blogs about DateTime Value: How To Strip Off Seconds
🧩 Data Modeling
- Jeffrey Wang (@jwang_pbi) blogs about Introducing DAX Window Functions (Part 2)
- Chris Webb (@cwebb_bi) writes about Why DAX Window Functions Are Important For Performance In Power BI DirectQuery Mode
- On the SQLBI blog, Marco Russo (@marcorus) talks about Many-to-Many Relationships – The Whiteboard #12, discusses What happened in DAX in 2022 and covers Custom Date Templates with Bravo for Power BI
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about ERROR – DAX Guide
- On the SQL Server Central blog, Koen Verbeeck (@Ko_Ver) discusses The Importance of a Good Data Model in Power BI Desktop
- On the MSSQLTips site, Harris Amjad (@mssqltips) describes How to Create a Star Schema in Power BI Desktop
- Reid Havens (@HavensBI) shares some Lessons learned After Two Years With a Large Model (with Alex Dupler)
- Mark Walter (@markwaltercpa) describes Building Blocks of Evaluation Context and DAX in Power BI and shares 10 tips that help me visualize DAX & Evaluation Context
- Sam McKay (@_EnterpriseDNA) covers Handling Multiple Dates in Power BI With DAX [2022 Update] and explains how to Analyze Margin Changes Over Time - Analytics With Power BI & DAX [2022 Update]
- Greg Deckler (@GregDeckler) explains How To Fix Measure Totals With Deneb
- Also on the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Using Dynamic Management Views (DMV) In DAX Studio and describe Template In Power BI: Using A Prebuilt To Load DMV Results
- Ignacio Barrau (@ignacho_07) covers [DAX] Debugueando código [Spanish]
📊 Report Authoring and Interactivity
- Reid Havens (@HavensBI) describes Multiple Text Options for Button Navigators in Power BI
- On the Enterprise DNA blog, Alexandru Badiu (@BadiuAlexandru) describes Power BI User Guide In Your Reports, covers Page Navigation In Power BI With Icons and blogs about Power BI Page Navigation Buttons
- Also on the Enterprise DNA blog, Sue Bayes (@sue_bayes) writes a number of blogs: Dynamic Header & Footer In Power BI, How To Sort & Filter Chart In Report Builder, Expression Report Builder: Examples and Guides and Microsoft Report Builder: Steps In Creating A List
- On the MSSQLTips site, Harris Amjad (@mssqltips) explains How to Create a Box and Whisker Plot in Power BI Desktop
- On the Towards Data Science blog, Jin Cui writes about Interactive Geospatial Visualization with Shape Map Visual in Power BI
- James Andrew (@MatadorSoftware) describes how to Use AI to Generate your Dashboard or Data App Design | Dalle 2, Power BI, Tableau, Looker
- Marcus Wegener (@PowerBIler) covers Reihenfolge bei vielen Seiten in Power BI Desktop ändern [German]
🚀 Deployment, Security and Operations
- On the phData, Manikanta Gudivaka (@phdatainc) explains How to Automate and Customize Power BI Deployments with CI/CD Pipelines
- Paul Turley (@paul_turley) describes DevOps & CI/CD for Power BI
- Philipp Lenz (@lenz_philipp) describes Dashboards, DirectQuery and what you should know about refreshing
- Chris Webb (@cwebb_bi) writes about Power BI DirectQuery Mode And Degenerate Dimensions
- Dhruvin Shah (@DhruvinShah16) explains how to Subscribe Power BI Report with Applied Filters
- David Eldersveld (@dataveld) discusses Searching for a Better Power BI Gen2 Capacity Analogy
- Soheil Bakhshi (@biinsightnz) delves into Endorsement in Power BI, Part 2, How to Endorse?
- Just Blindbæk (@justblindbaek) covers Extracting Power BI tenant metadata with Synapse Analytics
🌐 General
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 244 - News Wrap up for 2022
- Marc Lelijveld (@MarcLelijveld) blogs about Migrating to Power BI, but how?