Power BI Weekly
Issue #296 - 18th February 2025
One official article coming from the Fabric blog this week is an explainer around
How can I decide which protection method to use to protect my sensitive data in Fabric?
walking through the differences between
Purview Protection Policies
and
Data Loss Prevention policies with restrict access action
to secure your data. Elsewhere this week, Jess Hill has started a blog series around
Encoding categorical data for Power BI
, writing a detailed blog around
Label encoding vs one-hot encoding - which encoding technique to use?
. Kurt Buhler has written about why
Using pie charts is not the end of the world
, going through various examples about where it could or shouldn't be used. Finally, Zoe Douglas has continued the DAX series, sharing
DAX query 102: DAX formulas and measures with DEFINE MEASURE
.
🛠️ Data Prep
Rick de Groot (
@Rickmaurinus
) discusses
Understanding Metadata in Power Query M
Chris Webb (
@cwebb_bi
) describes
Reading Delta Metadata In Power Query
On the Power BI community blog, Anmol Malviya walks through
Using Variables While Creating Custom Columns in Power Query
Audrée Pellerin (
@lecfomasque
) covers
Intelligence artificielle dans Power BI : Fonctions personnalisées avec Azure Machine Learning [French]
Parul Sagar (
@parulsagar
) writes
Power BI Fuzzy Matching Demystified: Fix Messy Data Like a Pro
🧩 Data Modeling
On the RADACAD blog, Reza Rad (
@RADACAD_COM
) discusses
Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action
Zoe Douglas (
@MSPowerBI
) covers
DAX query 102: DAX formulas and measures with DEFINE MEASURE
On the Learning Science YouTube channel, Learning Science (
@learn_scitech
) explains
How to calculate dynamic RANK in Power BI? | RANKX function in DAX
Lars Schreiber (
@SchreiberLars
) covers
Top-Produkte und "Andere" korrekt sortieren | Power BI [German]
On the endjin blog, Jessica Hill (
@JessRoseHill_
) writes about
Encoding categorical data for Power BI: Label encoding vs one-hot encoding which encoding technique to use?
📊 Report Authoring and Interactivity
Kurt Buhler (
@kurtbuhler
) writes about
Using pie charts is not the end of the world
🚀 Deployment, Security and Operations
On the Fabric blog, Yael Biss (
@MSPowerBI
) writes
How can I decide which protection method to use to protect my sensitive data in Fabric?
On the Power BI community blog, Idriss Shatila explains how to
Exclude Table Refresh in Power BI using TMDL