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