Power BI Weekly
Issue #154 - 26th April 2022
Not a whole lot of content this week, and only really one update, which is that the On-premises data gateway April 2022 update is now available, which is compatible with the latest version of Power BI Desktop. Otherwise this week, Patrick Leblanc has presented a video Demystifying Custom Partitions in Power BI (a scary concept for many), Nikola Ilic has described another satisfying real-life use case of calculation groups in the blog How I transformed Excel “monster” into Power BI “beauty”, and Marco Russo has discussed some Side effects of rounding differences in Power BI - beware of your data types!
🛠️ Data Prep
- Chris Webb (@cwebb_bi) writes about Understanding Power Query Query Diagnostics Data With The Diagnostics.ActivityID M Function
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about Power BI Parameters Via Query Editor
- Patrick Leblanc (@GuyInACube) talks about Column From Examples in Power Query
- James Andrew describes The Ultimate Guide to If Statements in Power Query | Combining M Functions & And, Or, Not
- On the Learning Science YouTube channel, Learning Science describes Sentiment Analysis in Power BI Using AI Insights | Text Analytics in Power BI
- On the Power BI community blog, Liu Yang discusses Power BI Desktop groups consecutive dates
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Side effects of rounding differences in Power BI
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT – DAX Guide and describes PERCENTILE.EXC, PERCENTILE.INC, PERCENTILEX.EXC, PERCENTILEX.INC – DAX Guide
- Patrick Leblanc (@GuyInACube) delves into Demystifying Custom Partitions in Power BI
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes How I transformed Excel “monster” into Power BI “beauty”
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes DAX in Power BI Tutorial
- Ruth Pozuelo Martinez (@CurbalEN) describes DAX Fridays #215: Previous row in DAX non-accumulated values
- Hima Bindu Marri (@sivahimabindu) discusses DAX Studio Uses and how to use it
📊 Report Authoring and Interactivity
- Philipp Lenz (@lenz_philipp) blogs about R Visuals and Power BI
- Bas Dohmen (@HowToPowerBI) describes Target Area using Error Bars in Power BI and describes Getting Creative with Visuals in Power BI | High Low Lines
- Reid Havens (@HavensBI) describes Zero Performance Cost Grouped Object Borders
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) describes Explanatory and Exploratory Analysis using Power BI: Tell a story
🚀 Deployment, Security and Operations
- On the Power BI blog, Miguel Llopis (@mllopis) announces that the On-premises data gateway April 2022 update is now available
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Power BI Subscription Get Report Updates In Email
- Also on the RADACAD YouTube channel, Leila Etaati (@leila_etaati) provides an Introduction to Power BI Goals
- On the Bridge All blog, Zopaash Iqbal writes about Getting Started with Power BI Governance
🌐 General
- On the Power BI blog, Kelly Kaye (@MS_KellyKaye) announces Join Us! Power BI Dev Camp: Thursday 28 April 2022 at 11:00 AM PDT
- Reid Havens (@HavensBI) describes Meet reporTee - The Learning Power BI App for End-Users (with Štěpán Rešl)