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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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)
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.