Power BI Weekly Issue 149: 22nd March 2022
It's that time again - the March 2022 Feature Summary is now out. Quite a light set of updates this month. My highlights would be: Error Bars, which you can use to visualize the uncertainty in your data (though I'm sure some of you will find other glorious ways to use this new formatting feature), the new Geocoding support in the Azure Maps visual (no need to mess around with Lats and Longs again), and the new improved method for deploying Power BI Embedded multi-tenancy solution in scale (aka the GA of service principal profiles in Power BI Embedded), which circumvents the 1000 workspace per SP limitation that has existed up until now. Another niche feature that's landed in this month's Power BI Desktop release are the New Options For The Table.Buffer Function In Power Query - Chris Webb has shown how this argument can massively reduce the evaluation overhead for certain queries.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Adam Saxton (@GuyInACube) presents So, we just wait? Why is my Dataflow waiting?
- Chris Webb (@cwebb_bi) describes the New Options For The Table.Buffer Function In Power Query
- Imke Feldmann (@TheBIccountant) covers TRIMMEAN function for Power Query and Power BI and writes about the Excel WEEKNUM function for Power Query
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes Power Query Best Practices For Your Data Model
- Gašper Kamenšek (@ExcelUnplugged) explains how to Join Types in Power Query – Part 2: Lookup Dashboard
- Ruth Pozuelo Martinez (@CurbalEN) provides A technique to count anything in Power Query and some in DAX too
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes how to Import Web pages with Power BI
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) explains how to Get Files from SharePoint Folders in Power BI when Column Names or Column Numbers are Expected to Change
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) describes How to return BLANK instead of zero
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes ISERROR – DAX Guide
- Mimoune Djouallah (@mim_djo) explains how to Optimize PowerBI Direct Query performance by using Star Schema and Dual Mode.
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) describes Three steps for expanding my Tabular model
- On the Enterprise DNA blog, Antriksh Sharma (@_EnterpriseDNA) describes Expanded Tables In Power BI
- On the Power BI community blog, Yingjie Li describes how to Randomly filter with RAND or SAMPLE functions
- Daniil Maslyuk (@DMaslyuk) describes Power BI Antipatterns #5: CALCULATE
- Urish Arora (@urisharora) describes Calculate – One of the most used DAX functions and discusses Power BI – Use of RANKX function on multiple columns
- Bas Dohmen (@HowToPowerBI) discusses Week Calculations in Power BI #Shorts
- Reid Havens (@HavensBI) describes How To Organize Your DAX Measures Better
- Bernat Agulló (@AgulloBernat) describes Easy Management of Referential Integrity
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Adam Saxton (@GuyInACube) shares Some tips for your data labels in Power BI
- James Andrew describes how to Display Multiple DAX Measures Within a Single Power BI Visualization | Disconnected Slicers
- On the Learning Science YouTube channel, Learning Science talks about the Merged Bar Chart in Power BI by Nova Silva
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) writes about Natural Language based data exploration in Power BI
- Pascal Kiefer (@Pascal__Ki) explains How To Embed And Play Videos In Your Power BI Reports
- Bas Dohmen (@HowToPowerBI) discusses Think Twice Before Using a Pie Chart
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, Alon Baram announces the general availability of service principal profiles in Power BI Embedded
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 19 - Managing Power BI using the Power BI Admin APIs with Rick Xu
- Ruth Pozuelo Martinez (@CurbalEN) talks about Guest access in Power BI
- Philipp Lenz (@lenz_philipp) covers Page Level Security inside Power BI?
- Gilbert Quevauvilliers (@GilbertQue) covers Introduction into my blog series on "Which Power BI Reports do I have access to?"
- John White (@diverdown1964) explains how to Connect Power BI to Azure Monitor data using Direct Query with Azure Data Explorer
- On LaDataWeb, Ignacio Barrau (@ignacho_07) describes how to Obtener dataflows sin conexión a un dataset [Spanish]
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, Jeroen ter Heerdt (@jeroenterheerdt) highlights the Power BI March 2022 Feature Summary
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) lists the Top Five Myth and Misconceptions about Power BI
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Mar 19, 2022) (Member Chat 2nd Half)
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.