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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.