Power BI Weekly
Issue #164 - 5th July 2022
No announcements whatsoever this week, so straight onto the community articles. To kick things off, James Serra has written a great article about whether you should be using Power BI as a enterprise data warehouse solution, particularly given the addition of Datamarts. The key things to understand are the tradeoffs if you opt to do this - in some orgs, particularly those who are maybe starting out on their digital transformation journey, those tradeoffs may be OK - it all depends on the scenario. Then again, you may not label a data platform as an "enterprise data warehouse" in those scenarios. Anyway, do have a read. Elsewhere this week, Jess Hill has written about the differences between RELATED and RELATEDTABLE in DAX, Salvatore Cagliari has explored the Filter Context with DAX functions with a number of examples, and Prathy Kamasani has described how to use a Tree Map as legend on a page in Power BI.
                            
                            🛠️ Data Prep
                            
                        
                        - James Serra (@JamesSerra) blogs about Power BI as a enterprise data warehouse solution?
 - Chris Webb (@cwebb_bi) walks through Measuring Power Query CPU Usage During Power BI Dataset Refresh
 - Rick de Groot (@Rickmaurinus) blogs about List.Accumulate in Power Query (Explained with Examples) and explains how to Calculate Percentage of Total in Power Query
 - Meagan Longoria (@mmarie) walks through Generating Unicode Characters in Power Query
 - Chandeep Chhabra (@chandeep2786) describes how to Catch Error messages with TRY and CATCH in Power Query
 - Lars Schreiber (@SchreiberLars) shares Jahreswerte auf Basis des Vorjahres mit Power Query prozentual auf Monate verteilen [German]
 
                            
                            🧩 Data Modeling
                            
                        
                        - On the endjin blog, Jessica Hill writes about RELATED and RELATEDTABLE in DAX
 - On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about Exploring the Filter Context with DAX functions
 - Ruth Pozuelo Martinez (@CurbalEN) covers DAX Fridays 216: NETWORKDAYS function is finally here
 - Chandeep Chhabra (@chandeep2786) explains how to Find Products That Did Not Sell
 - Xiaoxin Sheng describes Comparison of the text string with multiple elements
 - Soheil Bakhshi (@biinsightnz) blogs about Thin Reports, Report Level Measures vs Data Model Measures
 - Reid Havens (@HavensBI) talks about The Best Data Type For Calendar Tables In Power BI
 
                            
                            📊 Report Authoring and Interactivity
                            
                        
                        - Bernat Agulló Roselló (@AgulloBernat) blogs about Normalizing Conditional Formatting Bars
 - Gaelim Holland (@_EnterpriseDNA) explains How To Create 3D Scatter Plots In Power BI Using Python
 - Dhruvin Shah (@DhruvinShah16) describes Key Influencer Visual in Power BI
 - On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) blogs about Analyzing key influencers in data with Power BI
 - Prathy Kamasani (@pkamasani) describes Using Tree Map as legend on a page in Power BI
 - Bas Dohmen (@HowToPowerBI) talks about Field Parameters in Power BI and explains how to Build this! Report design in Power BI | Full Tutorial
 - On the Perficient blog, Naziya Tabassum Khan describes Drill Down Feature in Power BI
 - Reid Havens (@HavensBI) describes Removing the Filter Pane Visibility Toggle for Bookmarks (with Mathias Thierbach)
 - Laura Graham-Brown (@Laura_GB) blogs about Charticulator Resources
 - James Andrew explains how to Improve your Dashboards with a Great Colour Palette Generator & Accessibility Checker
 - Also on the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) blogs about Generating smart narratives in Power BI
 - On the Learning Science YouTube channel, Learning Science explains How to Add, Update, Delete records in database or Spread Sheet from Power BI
 - On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains How to Use Python Script In Power BI and describes How Do You Connect Power BI To R Script Visual?
 
                            
                            🚀 Deployment, Security and Operations
                            
                        
                        - Neil Hambly (@Neil_Hambly) talks about Power BI Deployment Pipelines
 - On the Purple Frog Systems blog, Nick Edwards (@PurpleFrogSys) describes How to Trigger a Power BI Dataset Refresh via Azure Synapse Analytics in 3 Simple Steps.
 - Gilbert Quevauvilliers (@GilbertQue) writes about ALM Toolkit would not open (When using External Tools from Power BI Desktop)
 
                            
                            🌐 General
                            
                        
                        - On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 230 - Interview with Priya Sathy
 - On the MSSQLTips site, Scott Murray describes Power BI - How to Download and Get Started