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