Power BI Weekly
Issue #185 - 6th December 2022
The November Feature Summary has landed, with a number of great additions. It's now possible to have Unshared and unsynchronized axes for small multiples charts (so no more empty looking bar charts!), there's a new Optimize ribbon in Power BI Desktop, allowing you to do things like control when visuals refresh, configure settings, and access the performance analyzer (but unfortunately not auto-optimizing your DAX formulas!), and the new (yet secret) EVALUATEANDLOG and TOCSV/TOJSON functions have now been officially announced. Also, the On-premises data gateway November release has been release, bringing the gateway in line with the latest version of Power BI Desktop.
Elsewhere, we've published a couple of articles corresponding to the videos I shared last week - see our thoughts on Data Storytelling with Power BI: The World Bank World Health and Wealth Report and Accessible Data Storytelling with Power BI: Design Concepts and Accessible Colours.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) describes Web.Contents, Text Concatenation And Dataset Refresh Errors In Power BI/Power Query
- Ben Gribaudo (@bgribaudo) writes about the Extension.LoadFunction, Now With Enhanced Error Reporting!
- Mengting Zhu covers Datamart - Improve user experience
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) provides A Quick Overview On Different Power Query Tools In Power BI
- Bas Dohmen (@HowToPowerBI) describes Better Way to Change the Data Source
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shares a Masterclass - Microsoft Power Query Fundamentals Concepts with Tips & Tricks, shares a number of tutorials: PQ 9 - Sorting - Power Query - ETL, PQ 10 - Appending Data from Multiple Excel Worksheets, PQ 11 - Appending Data from Multiple Excel Workbooks Same Table Names, PQ 11.1 - Appending Data from Multiple Excel Workbooks Same Sheet Names, PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet Names, PQ 13 - Replace and Fill Down in Power Query, PQ 14 - Formatting Numbers and Dates in Power Query, PQ 15 - Adding Custom Calculated Columns in Power Query, PQ 16 - GroupBy & Merge in Power Query and PQ 17 - Unpivot Columns in Microsoft Power BI
- Also on the Enterprise DNA blog, George Mount (@_EnterpriseDNA) blogs about R For Power BI | A Beginner’s Guide
- Brian Julius (@_EnterpriseDNA) talks about The Most Powerful Function Call In Power BI
🧩 Data Modeling
- Chris Webb (@cwebb_bi) discusses What's New In Analysis Services 2022?
- Also on the SQLBI blog, Marco Russo (@marcorus) talks about Regular and Limited Relationships – The Whiteboard #10
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Extracting A Query Result In DAX Studio Using The Output Option and describe Data Cache: What It Is And How It Helps To Optimize Queries
- Sam McKay (@_EnterpriseDNA) describes Using The CROSSJOIN Function In Power BI - DAX Concepts [2022 Update]
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes ISSUBTOTAL – DAX Guide
- On the Prologika blog, Teo Lachev (@tlachev) covers Estimating DAX Query Completion Time and discusses Testing DAX Measures
- Kim Leblanc covers Les top mesures en langage DAX [French]
- On the Power BI community blog, Greg Deckler (@GregDeckler) explains how to Configure SQL Server Profiler as an External Tool for Power BI Desktop
📊 Report Authoring and Interactivity
- Paul Waller (@Crashbangwaller) covers Accessible Data Storytelling with Power BI: Design Concepts and Accessible Colours
- Barry Smart (@barry_j_a_smart) covers Data Storytelling with Power BI: The World Bank World Health and Wealth Report
- On the Learning Science YouTube channel, Learning Science talks about What is new in Small Multiples Charts in Power BI - November 2022 Update
- On Acuity Training, Ben Richardson (@AcuityTraining) writes about Power BI Report Builder
- On the Power BI community blog, Lucien Wang describes Power BI Report Builder
- Dhruvin Shah (@DhruvinShah16) explains how to Modernize Power BI Paginated Reports
- James Andrew (@MatadorSoftware) covers 2 Powerful Python Visuals You Should be Using in Power BI
- Gaelim Holland (@_EnterpriseDNA) explains How To Create Parallel Coordinate Plots With Python
- Matt Allington (@ExceleratorBI) describes Nesting Measures in Inforiver
- Andrzej Leszkiewicz (@avatorl) covers Florence Nightingale’s Rose Diagram
🚀 Deployment, Security and Operations
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway November release
- Pat Mahoney (@mahoneypa) talks about Incremental Refresh with SharePoint Files
- Dan English (@denglishbi) describes Azure Analysis Services (AAS) Migration to Power BI Premium Experience
- Gilbert Quevauvilliers (@GilbertQue) walks through Migrating AAS to Power BI Premium – Real World Example (Azure Analysis Services)
- On the Learning Science YouTube channel, Learning Science covers What is row level security?
- On Acuity Training, Ben Richardson (@AcuityTraining) walks through Implementing Row-Level Security In Power BI and describes How to Export From Power BI to Excel
- Sarah Krasnik (@sarahmk125) describes Why and How to Deprecate Dashboards
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 27 - Integrating Azure AD B2C with App-Owns-Data Embedding
- Soheil Bakhshi (@biinsightnz) writes about Content Endorsement in Power BI, Part 1, The Basics
🌐 General
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) announces Power BI November 2022 Feature Summary
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 242 - Power BI November 2022 Feature Summary
- Miguel Félix covers Atualização Power BI Novembro 2022 [Portuguese]
- Enterprise Dna explains how to Integrated Financial Reporting - Power BI Techniques For Accounting & Finance 2022 Update