Power BI Weekly
Issue #167 - 26th July 2022
A couple of articles related to the changes to Power BI custom visual licensing this week, where it's now possible to buy, sell, manage, and enforce licenses directly through the AppSource commercial marketplace. Learn more in the following articles: Partners: Introducing a new way to manage, enforce and transact licenses for Power BI visuals and Introducing a new way to purchase licensed Power BI visuals and manage licenses through Microsoft platforms.
Elsewhere this week, Ben Gribaudo has discussed the difference between the “Remove” or “Remove Other” functions when getting rid of columns in PQ, Gaelim Holland has described How To Create Enhanced Box Plots In Power BI Using Python, and Patrick Leblanc has shown an interesting new approach for dynamic Power BI visuals
Finally, I'd like to highlight a new hot-off-the-press book this week, which is Pro Power BI Dashboard Creation by Adam Aspin. The first in a trilogy of books, this one about getting up and running with building effective and appealing reports in Power BI, diving deep into the various visuals and interactivity features. Do check it out, and stay tuned for the remaining books!
🛠️ Data Prep
- On the Prologika blog, Teo Lachev (@tlachev) covers Datasets vs Datamarts
- Marcus Wegener (@PowerBIler) presents Berlin Power BI User Group: Exploring Power BI Datamarts [German]
- Ben Gribaudo (@bgribaudo) blogs about Getting Rid of Columns: “Remove” or “Remove Other”?
- Rick de Groot (@Rickmaurinus) explains how to Transform Column Names in Bulk in Power Query and discusses Fix Last Refresh Date/Time in Power BI (Incl Daylight Savings)
- Also on the Power BI community blog, Lucien Wang describes how to Make column numbering not consecutive over the whole dataset but just for equal column names
- Also on the Power BI community blog, Stephen Tao describes how to Skip null values to add index columns
- Ruth Pozuelo Martinez (@CurbalEN) covers Variables in power query | How and practical use case
- Steve de Peijper (@bi2analytics) writes about CBind in Power M (Power Query)
- Lars Schreiber (@SchreiberLars) covers Eine HEUTE-Funktion In Power Query Erstellen [German]
- On the Power BI community blog, Ted Pattison (@TedPattison) announces What Is Synapse Link and How It's Used to Connect from Power BI to Dataverse
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Rolling average with working days in DAX
- On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) writes about The DAX Studio EVALUATE Keyword: Basic Examples and writes about Data Indexing In Vertipaq: Row Store Versus Column Store
- Reid Havens (@HavensBI) walks through Building Your First Calendar Table in Power BI
- Greg Deckler (@GregDeckler) explains How To Easily Fix Incorrect Measure Totals In Power BI
- Soheil Bakhshi (@biinsightnz) writes about Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD
📊 Report Authoring and Interactivity
- On the Power BI blog, Ranin Salameh (@rsalameh) announces Partners: Introducing a new way to manage, enforce and transact licenses for Power BI visuals and announces Introducing a new way to purchase licensed Power BI visuals and manage licenses through Microsoft platforms
- Microsoft Power BI (@MSPowerBI) explain how to Integrate Power BI reports into PowerPoint presentations
- Patrick Leblanc (@GuyInACube) provides A new approach for dynamic Power BI visuals?
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes Infographic Designer Visuals in Power BI
- Gaelim Holland (@_EnterpriseDNA) explains How To Create Enhanced Box Plots In Power BI Using Python
- James Andrew (@MatadorSoftware) describes how to Massively Improve Your Power BI Tables with This Simple Trick
- Tim Weinzapfel (@EnterpriseDNA_) discusses The Next-level KPIs Table In Power BI
- Hima Bindu Marri (@sivahimabindu) blogs about Cross-filtering vs Cross-highlighting in Power BI
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) explains How to perform Process Mining using Power BI
🚀 Deployment, Security and Operations
- Adam Saxton (@GuyInACube) describes The most underused feature in Power BI?
- Reid Havens (@HavensBI) describes Power BI REST APIs 101 & Useful Techniques (with Rui Romano)
🌐 General
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 231 - Power BI July 2022 Feature Summary
- Chris Webb (@cwebb_bi) writes Yet Another Power BI (And Synapse) Book Roundup