Power BI Weekly

Issue #105 - 13th April 2021

A few updates this week: Object-Level Security (OLS) is now generally available in Power BI Premium and Pro, there's a new sharing experience coming soon (shareable links), and we've been told about What's New In Dataflows - April 2021 including terminology updates ("entities" are now called "tables", and "fields" are called "columns").

Elsewhere this week, Nikola Ilic has written the final part of a series on Query folding in Power BI - tricks, lies & ultimate performance test, Sam Fischer has described How to reset calculation groups in a custom tooltip or drillthrough page, and Priscilla Camp has shared A quick trick using the Relative Date Filter in Power BI.

Finally, don't forget about the Power BI Summit taking place April 19-23 - lots of your favourite speakers in a jam-packed schedule covering all areas of Power BI.

🛠️ Data Prep

On the Power BI blog, Charles Webb (@CharlesWebb22) describes What’s New In Dataflows – April 2021
Chris Webb (@cwebb_bi) writes about Importing Data From ADLSgen2 Into Power BI: Summary Of Findings
On the Towards Data Science blog, Nikola Ilic (@DataMozart) covers Query folding in Power BI—tricks, lies & ultimate performance test
On the CSG Pro blog, Brian Grant (@BrianGrantBI) writes about Combining Conflicting Customer Names Using Power Query and describes Creating a Local ID in Power Query
On the Power BI community blog, Yingying Ruan blogs about Rows and columns conversion and bulk renaming of columns
On the Data Bear blog, Mariska Oosthuizen explains how to Add a Custom Column in Power BI
Jon Acampora (@excelcampus) talks about 15 Shortcuts for Power Query
Bas Dohmen (@HowToPowerBI) explains how to Convert Your Query into an M Function | Combine Data from Multiple Excel Sheets in Power BI
Hima Bindu Marri (@sivahimabindu) describes how to Dynamically remove columns Power Query
Laura Graham-Brown (@Laura_GB) describes Power BI Desktop Connecting to Dataverse

🧩 Data Modeling

On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Computing rolling average in DAX, describes Rolling 12 Months Average in DAX and talks about Solving currency conversion – Unplugged 14
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: CONCATENATE, CONCATENATEX – DAX Guide, EXACT – DAX Guide, FIND – DAX Guide, FIXED – DAX Guide, FORMAT – DAX Guide and LEFT, RIGHT, MID, LEN – DAX Guide
Patrick Leblanc (@GuyInACube) explores the Power BI Model View
Sam Fischer (@ApexInsightsPBI) highlights 10 ways you can use Calculation Groups in Power BI and describes How to reset calculation groups in a custom tooltip or drillthrough page
On the Towards Data Science blog, Salvatore Cagliari writes about A little DISTINCT challenge with DAX optimisation
On the BI Power blog, Didier Terrien shares the DAX debugger in Power BI Sidetools
Reid Havens (@HavensBI) talks about Power BI Sidetools - All Kinds of AWESOME with Didier Terrien
On the CSG Pro blog, Brian Grant (@BrianGrantBI) talks about Time Is On Your Side: An Intro to DAX Time Intelligence
Ruth Pozuelo Martinez (@CurbalEN) covers DAX Fridays #203: Examples of MAX calculations of groups and subgroups
Sam McKay (@_EnterpriseDNA) explains how to Calculate Average Per Day / Month / Year In Power BI Using DAX
Greg Philps talks about Comparing Top N And Average Of Others In Power BI
Brian Julius writes about Three Types Of Tables In Power BI And Why The Distinctions Matter
Matthew Peterson (@mattpetersonbi) describes how to Use Switch over IF To Make Life Easier
On the SQL Shack blog, Rajendra Gupta provides An overview of Power BI data models
Ben Lawrence & Ahmed Abualsoud talk about Efficiency Improvements in PBI Datasets: What We’ve Learned

📊 Report Authoring and Interactivity

On the Power BI community blog, Priscilla Camp (@ITDataDiva) provides A quick trick using the Relative Date Filter in Power BI
On the Prologika blog, Teo Lachev (@tlachev) lists the Top 5 Power BI UX Gaps
On the Purple Frog Systems blog, Nick Edwards describes How to make your matrix column widths all equal to each other in Power BI using DAX.
Bas Dohmen (@HowToPowerBI) discusses Custom Formatting in Power BI
Ruth Pozuelo Martinez (@CurbalEN) writes about 2 Power BI matrix hacks you wish you knew and shares I bet you didn't know at least one of these Power BI hacks
Paul Lucassen explains How To Create Custom Legend For Power BI Map Visuals
Bas Dohmen (@HowToPowerBI) covers Status Bar in Power BI
Dhruvin Shah (@DhruvinShah16) provides an Introduction to Power BI Paginated Reports and shares an Overview of Power BI Report Builder
Soheil Bakhshi (@biinsightnz) walks through Exporting Power BI Desktop Data Using Power BI Exporter
Also on the Power BI community blog, AbhiSSRS writes about Power BI Paginated Reports with Custom Code (VB Code)

🚀 Deployment, Security and Operations

On the Power BI blog, Sujata Narayana highlights the New sharing experience coming soon
Gilbert Quevauvilliers (@GilbertQue) explains How to complete granular deployment of Power BI Desktop changes to the Power BI Service (Using PPU)
Reid Havens (@HavensBI) talks about the New & Improved Template App Install Experience

🌐 General

On the Power BI blog, Ogbemi Ekwejunor-Etchie writes that Object-Level Security (OLS) is now generally available in Power BI Premium and Pro!
Also on the Power BI blog, Kelly Kaye (@MS_KellyKaye) explains how to Join us! Power BI Summit April 19-23
Patrick Leblanc (@GuyInACube) describes Power BI for the NON-TECHnical person
Adam Saxton (@GuyInACube) shares Power BI tips from the Pros – LIVE w/ Matthew Roche (April 10, 2021)
On the Power BI community blog, Heather Newman (@heddanewman) writes about User Groups: Get signed up for our Public Preview
On the MSSQLTips site, Kenneth A. Omorodion blogs about Power BI for Business Intelligence
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 186 - Community News
The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 147
On the Towards Data Science blog, Nathan Cheng writes Minimum Viable Streaming Dashboard in Power BI: Part 3
Ted Pattison (@TedPattison) describes Developing with Net 5 and App Owns Data Embedding