Power BI Weekly
Issue #283 - 5th November 2024
One announcement from the Fabric side this week which will be relevant to some Power BI users - that's the New Features and Enhancements for Virtual Network Data Gateway, including the max cluster size being increased from 5 to 7. Elsewhere this week, Paul Turley is back with a refreshed article on Doing Power BI the Right Way in 2025 (and the last part of 2024 I should think!), highlighting numerous recommended practices you should be considering when delivering your Power BI projects. Stay tuned to Paul's blog for more detailed write-ups on those topics. Touching on one of those topics, Jon Stjernegaard Vöge has written about The simplest Version Control setup possible for Power BI: Sharepoint/OneDrive + automatic publishing, a technique that we are huge proponents of here at endjin - enabling a business-user friendly way of achieving version control in Power BI. Finally, Pat Mahoney has shared a useful video titled EAGER to Optimize IF and SWITCH measures?, walking through common ways of improving the performance of these conditional expressions, including explaining the lesser-known IF.EAGER function that you can often use directly in place of normal IF statements.
🛠️ Data Prep
- On the Power BI community blog, Milan Mejzr writes about Self referencing query in Power Query
- Also on the Power BI community blog, Ignacio Barrau (@ignacho_07) writes about Web Source to Avoid Power BI Gateway with Azure Functions
- Also on the Power BI community blog, Anmol Malviya describes how to Import Microsoft Planner Data into Power BI Using Power Automate and SharePoint
🧩 Data Modeling
- Chris Webb (@cwebb_bi) writes about Different Ways To Replace Blanks With Zeros In DAX
- Chandeep Chhabra (@chandeep2786) describes how to Fix Those Blank Values in Your Power BI Report
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) covers Power BI Performance Tuning Aggregation Part 1 Overview
- On the Access Analytic blog, Melina Louzada describes Mastering Dynamic Measure Formatting in Power BI | Part 4: Dynamic Formatting Based on Value Ranges
- Pat Mahoney (@mahoneypa) writes Eager to Optimize IF and SWITCH measures?
- On the Tabular Editor blog, Morten Lønskov announces Tabular Editor 3: October 2024 Release and announces Free DAX Optimizer Access in Tabular Editor 3
- Mark Walter (@markwaltercpa) writes about Changing Auto-Exist with Filter Value Behavior
📊 Report Authoring and Interactivity
- Reid Havens (@HavensBI) describes Exploring Practical Front-End Techniques for Power BI Reporting (Gustaw Dudek)
- On the Power BI community blog, Kedar Pande delves into Color Choice: How a Minimalist Approach Enhances User Experience
🚀 Deployment, Security and Operations
- On the Fabric blog, Leo Li highlights the New Features and Enhancements for Virtual Network Data Gateway
- On the phData blog, Manikanta Gudivaka (@phdatainc) explains How to Refresh a Single Table in a Power BI Semantic Model
- Jon Stjernegaard Vöge blogs about The simplest Version Control setup possible for Power BI: Sharepoint/OneDrive + automatic publishing
- Philipp Lenz (@lenz_philipp) describes Passing parameters/variables to Tabular Cubes from Power BI Emedded
🌐 General
- Paul Turley (@paul_turley) discusses Doing Power BI the Right Way in 2025