Power BI Weekly

Issue #127 - 28th September 2021

This week we've been given the Power BI September 2021 Feature Summary, including nice little updates such as Line chart series labels and the new Shortcut expression for CALCULATE which now supports aggregation functions. Also highlighted in that article is the New Admin API to determine who has access to what (Public Preview) and the public preview of Insights, an intelligent new feature in the Power BI Service helping you find the insights in your report more easily. And last but not least, we've been told about the Power BI Embedded Analytics Playground Updates and that the On-premises data gateway September 2021 update is now available.

Elswhere this week, Marco and Alberto have written a comprehensive blog describing how to control drillthrough in Excel PivotTables connected to Power BI or Analysis Services and Marc Lelijveld has put together a nice diagram/flow chart describing the questions to ask when considering Do I need Power BI Premium?

🛠️ Data Prep

Ben Gribaudo (@bgribaudo) walks through Describing a Functions Record Parameters and writes about Relationship Columns and Their Names
On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) blogs about Table Value – A Common Structured Value In Power BI and describes how to Easily Compare Two Tables in Power Query
Rick de Groot (@Rickmaurinus) shares a few blogs: Replace Values in Power Query – Ultimate Guide, Pivot Text Values in Power Query – Explained and 3 Ways to Add Leading Zero to Number in Power Query
On the Burningsuit blog, Alan Harman-Box writes about I have the Power(query): using Power Query to call REST APIs
On the Power BI Community blog, Yingjie Li describes Batch conversion of headers and column values
Parker Stevens (@PowerBIElite) describes how to Bulk Write Back to SQL from Power BI

🧩 Data Modeling

Phil Seamark (@PhilSeamark) talks about Power BI Multiple Aggregations tables
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: ROW – DAX Guide, DATATABLE – DAX Guide and DateTime – DAX Guide
Also on the SQLBI blog, Marco Russo & Alberto Ferrari blogs about Controlling drillthrough in Excel PivotTables connected to Power BI or Analysis Services
On the Forsight BI blog, Ahmed Oyelowo (@AhmedOyelowo) shares a DAX Formula To Rank Based On Multiple Values
Patrick Leblanc (@GuyInACube) describes One Click Calculation Group in Power BI
Adam Saxton (@GuyInACube) shares DAX! Uggg – Where do you start? | Power BI
Antriksh Sharma (@AntrikshShar) discusses SAMEPERIODLASTYEAR in Case of Missing Years in DAX for Power BI, Power Pivot, & SSAS and explains how to Find Sales on the Last Date with DAX in Power BI
Pat Mahoney (@mahoneypa) writes that It's About Time - Part One
Hima Bindu Marri (@sivahimabindu) describes how to Sync Slicers in Power BI
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) blogs about Power BI HR Pattern | DAX Measures for the Last Position to Date | Last Status to Date, explains how to Generate Year and Month Combinations in Power BI Report using DAX and talks about What a Power BI Hierarchy Is and How to Use it
On the Tessellation Tech blog, Gavin Pedersen covers Power BI’s SUM vs SUMX: What is the Difference, REALLY?
On the Purple Frog Systems blog, Joe Billingham walks through Increasing DAX Filter Speed and Efficiency
On the Power BI Tips and Tricks blog, James Bartlett shares Three New Time-Saving Scripts for Tabular Editor
On the Power BI Community blog, Greg Deckler (@GregDeckler) writes Localizing the Data Model - Part 4

📊 Report Authoring and Interactivity

On the Power BI blog, Ancy Philip (@ancyphilip) announces the public preview of Insights
Reid Havens (@HavensBI) talks about Improving the Time Intelligence Slicer & Avoiding Circular Dependencies
Matt Allington (@ExceleratorBI) writes about Dynamic Commentary in Power BI
Mike Allen (@MikeAinOz) talks about Paginated Reports for Planner Reporting
On the Prologika blog, Teo Lachev (@tlachev) describes how to Drillthrough Paginated Reports
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) provides A better way to Mobile
David Abu talks about Conditional Formatting in Power BI
On the Learning Science YouTube channel, Learning Science talks about Line Chart Series Labels in Power BI
Dhruvin Shah (@DhruvinShah16) talks about Series Labels for Power BI Line Charts, Insights in Power BI Announcing Public Preview for Power BI Insights September 2021 Updates and Next-Generation Power BI Buttons
Bas Dohmen (@HowToPowerBI) blogs about Dealing with double headers in Power BI

🚀 Deployment, Security and Operations

On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes that On-premises data gateway September 2021 update is now available
On the Power BI blog, Noam Raveh shares some Power BI Embedded Analytics Playground Updates
On the Power BI blog, Rick Xu announces the A New Admin API to determine who has access to what (Public Preview)
Marc Lelijveld (@MarcLelijveld) wonders Do I need Power BI Premium?
Gilbert Quevauvilliers (@GilbertQue) describes How to show a different contact for each report/dashboard within a Power BI App
On LaDataWeb, Ignacio Barrau (@ignacho_07) describes how to Ejecutar DAX con Power Bi Rest API [Spanish]

🌐 General

On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares the Power BI September 2021 Feature Summary
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 205 - Interview with Patrick Leblanc
The Knee-Deep in Tech team (@KneeDeepinTech) describes Podcast episode 159
Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (September 25, 2021)
On the Power BI community blog, Ted Pattison (@TedPattison) highlights the Power BI Dev Camp: September 30th-Developing Power BI for Dataverse + PowerApps, and Dynamics 365 CE