Power BI Weekly

Issue #45 - 11th February 2020

Quite an active week in the Power BI ecosystem this week, so take your time digesting this content. Let's start with the one update from this week, which is the Power BI Developer community February 2020 update. Elsewhere, Michal Dvorak has provided a tool to Convert a Power BI Dataset To a Power BI Dataflow, David Eldersveld has described how to Use Windows Shortcuts to Open Power BI with a Default File, and Leila Etaati has written about the Decomposition Tree Visual in Power BI- Part Two.

A couple of weeks ago, a number of endjineers attended NDC London, which was a great success with many fascinating sessions. We've distilled all of our experiences into a number of blogs, for example, Jon George has written about dangerous AI, microservices, diagnostics and Blazor in his overview of day 1, whilst Ian and Carmel have also provided their takes on the day. Oh - and so have I!

Finally, Carmel has written a brilliant, brave, thought-provoking blog post about her experiences with mental health and managing the challenges of remote working. It is well worth a read, whether or not you work from home.

🛠️ Data Prep

Ben Gribaudo (@bgribaudo) writes Power Query M Primer Part 16: Type System I
Chris Webb (@cwebb_bi) shares An M Function To Help You Explore Power Query Diagnostics Data
On the Power BI community blog, Michal Dvorak (@nolockcz) describes How To Convert a Power BI Dataset To a Power BI Dataflow
Matt Allington (@ExceleratorBI) explains how to Remove Duplicates and Keep the Last Record with Power Query
Gilbert Quevauvilliers (@GilbertQue) discusses Connecting to Snowflake DB in Power BI
On the MSSQLTips site, John Miner (@JohnMiner3) writes about a Power Query Source for SQL Server Integration Services

🧩 Data Modeling

Joseph Yeates (@FthrsAnalytics) discusses Creating an Income Statement with DAX in Power BI – Part 2
On the SQLBI blog, Marco Russo (@marcorus) blogs about Optimizing LASTNONBLANK and LASTNONBLANKVALUE calculations
Patrick Leblanc (@GuyInACube) explains how to Create custom keys for your Power BI relationships
On the Towards Data Science blog, Bruno Bossaerts describes how to Add Category Other to Charts
Parv Chana (@parvchana) explains how to Restrict number of data points in Power BI visuals
Imke Feldmann (@TheBIccountant) writes about Dynamic Benford's Law measures in Power BI and Power Pivot
On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Find a Text Term in a Field in Power BI Using DAX Functions
On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes Three Ways to Create a Calendar Table
Phil Seamark (@PhilSeamark) writes about Overriding slicers
Darren Gosbell (@darrengosbell) wonders Do the ALL() and REMOVEFILTERS() functions always work correctly in DAX?
Also on the Power BI community blog, Amit Chandak (@amitchandak78) walks through Decoding Direct Query in Power BI Part 1: Time Intelligence in Direct Query : SQL Server
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains how to See Changing Results Using Calculated Columns In Power BI, writes about Common Customer Behavior Analysis Using Power BI and describes how to Use Power BI Analytics To Check If Revenue Growth Is Profitable

⚙️ Report Design and Visualizations

On the RADACAD blog, Leila Etaati (@leila_etaati) writes about the Decomposition Tree Visual in Power BI- Part Two
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about a Data Visualization Technique in Power BI – Multi Measure Dynamic Visuals
Devin Knight (@knight_devin) presents Power Platform Quick Tips – Episode 04: Hiding Power BI Visuals Interactivity
On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes how to Cross Highlight Excel Charts
Patrick Leblanc (@GuyInACube) presents Want a custom LEGEND for your Power BI visual? WATCH THIS!
Sebastian Zolg (@sebastianzolg) writes Are You on Track - Communicate Your Strategic Themes on an Interactive Roadmap with No-Code.
On the Prologika blog, Teo Lachev (@tlachev) blogs about Power BI Slicers and Filters
On the Visual BI blog, Bhupinder Singh writes about the Waterfall Chart – Advanced Custom Visuals for Power BI
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) talks about Layouts for Company Templates

🚀 Deployment, Security and Operations

Adam Saxton (@GuyInACube) talks about What you NEED to know about Publish to Web in Power BI
On the Forsight BI blog, Ahmed Oyelowo writes about the Most Common Power BI Installation Errors And Their Solutions

🌐 General

On the Power BI blog, Amit Shuster provides the Power BI Developer community February 2020 update
David Eldersveld (@dataveld) provides a Quick Tip: Use Windows Shortcuts to Open Power BI with a Default File
Adam Saxton (@GuyInACube) highlights that Power BI updates have started again... (Roundup | February 3, 2020)
On the Power BI community blog, Syndicate_Admin writes that The Global Power Platform Boot camp is coming to a city near you
Prathy Kamasani (@pkamasani) blogs about the Jan 2020, London PowerBI UG DataViz
Also on the Power BI community blog, Sivakumar Harinath writes about Power BI Training Content
Also on the Power BI blog, Kelly Kaye highlights a couple of webinars: Top Tips and Tricks from PowerBI.Tips (2019 Edition) by Mike Carlo and covers Self-Service AI in Power BI Desktop
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes about the Milwaukee Brew City PUG – Jan 2020
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 135 - Early February Catch Up