Power BI Weekly

Issue #106 - 20th April 2021

Hope those attending the Power BI Summit are enjoying themselves so far. This week we've been given the Power BI April 2021 Feature Summary, where a couple of the main announcements are about the new Power Automate visual for Power BI reports, allowing you to act on the insights you find when exploring a Power BI report in a contextual manner, and the new Charticulator visual letting you create your custom visuals right from within Power BI. Both visuals are in preview.

Elsewhere this week, Alberto Ferrari has written a thorough technical blog on the age-old question: Star schema or single table. Gil Raviv has shared the New App: Dataflow Snapshots Analysis, helping you compare different Dataflow snapshots between refreshes. And Alex Jankowski has described Building a SelectQuery Function in Power Query, helping dynamically select an M query given an input selection.

🛠️ Data Prep

Chris Webb (@cwebb_bi) discusses Power BI Dataflow Performance, Premium Per User And The Enhanced Compute Engine
On the DAX Pro Services blog, Jesus Gonzalez writes about a Naming convention for Power Query steps
Belinda Allen (@MsBelindaAllen) discusses Referencing a Query in the Query Editor and talks about Removing Duplicate Records in the Query Editor
Mike Allen (@MikeAinOz) writes about Planner Data in Power BI
On the Excelguru blog, Alex Jankowski walks through Building a SelectQuery Function in Power Query
On the Purple Frog Systems blog, Jon Fletcher blogs about Power BI – Enable Load
Brian Julius discusses Incorporating M In Custom Column
On the Towards Data Science blog, Patrick Pichler describes Driving Insights at Scale Using a Common Data Model CDM on Azure Data Lake

🧩 Data Modeling

On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) delves into Power BI – Star schema or single table
On the SQLBI blog, Marco Russo (@marcorus) talks about Increasing compression in Power BI and Analysis Services – Unplugged #15
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: LEFT, RIGHT, MID, LEN – DAX Guide, LOWER, UPPER – DAX Guide, REPLACE – DAX Guide, REPT – DAX Guide, SEARCH – DAX Guide and SUBSTITUTE – DAX Guide
Chandeep Chhabra (@chandeep2786) blogs about Understanding the DAX Filter Function
On the SQL Shack blog, Rajendra Gupta writes about Azure Analysis Services and Power BI Live connections
Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #204: Slice by the results of a measure
Pat Mahoney (@HoosierBi) writes about No Sort Date Tables
Greg Philps explains How To Create Multilingual Power BI Reports
Reid Havens (@HavensBI) talks about Relationship Issues With DateTime Data Types in Power BI

📊 Report Authoring and Interactivity

On the Power BI blog, Roseanne Levasseur announces Announcing the new Charticulator visual (Public Preview)
Also on the Power BI blog, Sujata Narayana announces the new Power Automate visual for Power BI reports
Daniel Marsh-Patrick (@the_d_mp) highlights that Deneb Now Available for Public Preview
Marc Lelijveld (@MarcLelijveld) describes how to Jump from one Power BI report to another by using cross-report drill through
Adam Saxton (@GuyInACube) describes Mastering Power BI Bookmarks
Mara Pereira (@datapears) describes Data Storytelling in Power BI - Bar Charts
Bas Dohmen (@HowToPowerBI) describes how to Switch between percentage and absolute values in one visual | Calculation Groups in Power BI
Hima Bindu Marri (@sivahimabindu) describes how to Show all Categories in a visualization in Power BI
Belinda Allen (@MsBelindaAllen) walks through Creating a Template Page for Consistency in Microsoft Power BI
Dhruvin Shah (@DhruvinShah16) discusses Power BI Paginated Report Series - 02: Overview of Power BI Report Builder
Jarret Moore describes Using The New Field List In Power BI Desktop and writes about the Newly Released Charticulator Visual In Power BI
Bas Dohmen (@HowToPowerBI) talks about Charticulator in Power BI
On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes Comment produire un état des résultats dans Power BI? [French]
On Qiita, Yugo Shimizu (@yugoes1021) writes about the Power Automate visual for Power BI report を試してみた [Japanese]

🚀 Deployment, Security and Operations

Philipp Lenz (@lenz_philipp) writes about Multiple Row Level Security Roles and Object Level Security?
On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) blogs about Power BI issues with switching tenants
On the CSG Pro blog, Ferenc Csonka (@ferenc_csonka) talks about the XMLA Read-Write Endpoint: The Cornerstone for Power BI as an Enterprise BI Solution
Also on the CSG Pro blog, Ajay Kumar (@BIConsultingPr1) explains How to Use Data Sensitivity Labels in Power BI
Gilbert Quevauvilliers (@GilbertQue) describes How to update or create a measure to Power BI Premium Per user without having to publish entire dataset
Gil Raviv (@gilra) highlights the New App: Dataflow Snapshots Analysis and blogs about Snapshot analysis for your Power Apps Analytical Dataflows
Laxmi Arte (@ClaritiData) explains how to Add Power BI reports to Microsoft Teams
Sam McKay (@_EnterpriseDNA) explains how to Immerse In Data Insights Using Power BI Within Microsoft Teams

🌐 General

On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) describes Power BI April 2021 Feature Summary
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) presents Episode 187 - Interview with Stephanie Bruno
Kasper de Jonge (@kjonge) describes The rise and history of Power BI with Amir Netz
Michael explains how to Automate Building a Power BI Report from Survey Results
Adam Saxton and Patrick Leblanc (@GuyInACube) explains how to Let’s continue the big data discussion with SQLBI (April 17, 2021)