Power BI Weekly
Issue #139 - 11th January 2022
There's been tumbleweed over on the Power BI blog this week, so if you're after some exciting official announcements and updates, you'll have to look elsewhere I'm afraid. However, there have been plenty of great articles across the community this week. It would be remiss of me not to highlight some great posts from my colleagues here at endjin - Eli has provided a lovely 101 on Evaluation Contexts in DAX - Filter and Row Contexts (arguably the most important concept in DAX!), James has talked about Why you should care about the new Power BI ExecuteQueries API, and finally Paul has provided a designer's perspective on Generating custom themes in Power BI, sharing some tips and tricks to help you think more like a designer. In fact, on that last point, Greg Deckler has compared and contrasted a bunch of available Power BI Theme Generators (some at a cost) - really useful reference point to find the tool you most prefer.
Elsewhere this week, Patrick Leblanc has explored a lesser-known feature: Streaming Dataflows in Power BI, and Matthew Roche has written a blog emphasizing the importance of Understanding the problem domain - don't waste time solutionizing before you have a comprehensive understanding of the problem at hand.
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) covers Custom Folding Arbitrary Functions: OnInvoke & Table.ViewFunction
- On the MSSQLTips site, Kenneth A. Omorodion describes how to Concatenate Strings in Power BI Using Power Query M Language
- Allison Kennedy explains how to Get Data from SharePoint Files into Power BI
- Patrick Leblanc (@GuyInACube) presents Exploring Streaming Dataflows in Power BI
🧩 Data Modeling
- On the Towards Data Science blog, Salvatore Cagliari shares An unexpected lesson with calculating currency conversions in DAX
- Marc Lelijveld (@MarcLelijveld) shares Power BI Model Documenter v2
- Matt Allington (@ExceleratorBI) discusses Using Macros in Tabular Editor 3
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about LN, LOG, LOG10, EXP – DAX Guide and and SINH, COSH, ASINH, ACOSH, TANH, ATANH, COTH, ACOTH – DAX Guide
- On the SQL Server Central blog, Adam Aspin describes How to filter DAX for paginated reports
- Reid Havens (@HavensBI) discusses the Power BI Cleaner - External Tool (with Imke Feldmann)
- On the endjin blog, Elisenda Gascon (@elisendagascon) writes about Evaluation Contexts in DAX - Filter and Row Contexts
- On the Learning Science YouTube channel, Learning Science talks about the SUM and SUMX Functions in Power BI
- The Power BI team (@MSPowerBI) shares: Learn about hybrid tables in Power BI premium
- Bas Dohmen (@HowToPowerBI) describes Calculation Groups in Power BI
- Yugo Shimizu (@yugoes1021) shares [Power BI Tips] スタースキーマへの道 ~ モデリングってたぶんこれが基本 ~ [Japanese]
📊 Report Authoring and Interactivity
- On the endjin blog, Paul Waller (@Crashbangwaller) covers Generating custom themes in Power BI – A designer's perspective
- On the Power BI community blog, Greg Deckler (@GregDeckler) blogs about Power BI Theme Generators
- Laura Graham-Brown (@Laura_GB) writes about a Charticulator Simple Custom Chart
- Olivier Travers (@otravers) writes about Advanced Power BI Custom Visuals: Options & Tradeoffs
- Greg Philps describes Exploring The Deneb Custom Visual In Power BI
- Chandeep Chhabra (@chandeep2786) presents Custom made Heat Maps using DAX
- Bas Dohmen (@HowToPowerBI) presents I Changed My Mind About GIFS Animated Images in Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Sparklines in Power BI
- On the Learning Science YouTube channel, Learning Science talks about Pie and Donut Chart Rotation in Power BI - A technique to enable missing data labels
- Rick de Groot (@Rickmaurinus) discusses The Secrets of Drillthrough in Power BI
🚀 Deployment, Security and Operations
- On the endjin blog, James Broome (@jamesbroome_) writes about Why you should care about the new Power BI ExecuteQueries API
- Chris Webb (@cwebb_bi) describes how to Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 2: Dataset Refreshes
- Bernat Agulló (@AgulloBernat) talks about Bringing Tabular Editor C# scripts to the next level
- Philipp Lenz (@lenz_philipp) writes Continuous Deployment of Azure Analysis Services Cubes – Part 2 SQL Authentication
🌐 General
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 217 - Power BI 2021 Year in Review
- Matthew Roche (@SQLAllFather) blogs about Understanding the problem domain
- Marcus Wegener (@PowerBIler) presents Hey Peter! Power BI in Präsentation anstelle von PowerPoint nutzen [German]
- On the Power BI Tips and Tricks blog, the Explicit Measures podcast team (@PowerBITips) talks about Continuously Improving User Experience