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