Power BI Weekly Issue 254: 16th April 2024
The Power BI April 2024 Feature Summary came out last week, including (amongst other updates) a Brand New Visual – 100% Stacked Area Chart and a cool new Metadata Scanning sample app to help catalog and report on your organization’s Fabric items. We've also been told about the new functionality to Deliver report Subscriptions to OneDrive and SharePoint (Preview), although such Subscriptions are still only possible with a capacity-backed workspace (though PPU support is coming soon apparently).
Elsewhere this week, Chandeep Chhabra has hosted Oz du Soleil presenting a Power Query Masterclass on Lists, Gilbert Quevauvilliers has described how you can now create DAX measures directly in the Power BI Service using Visual Calculations, Erik Svensen has also shown a neat trick about how you can use Visual Calcs to Make sure the data label is visible in a bar chart, and Kurt Buhler has written a detailed article about the various options to configure Tabular Editor and Fabric Git integration.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) writes about New Semi Join, Anti Join And Query Folding Functionality In Power Query
- Rick de Groot (@Rickmaurinus) discusses The Definitive Guide to Power Query M - What to expect? and explains how to Create a Join based on Date Range in Power Query
- Patrick Leblanc (@GuyInACube) talks about Power Query within Power BI Report Builder
- Chandeep Chhabra (@chandeep2786) presents Power Query Masterclass on Lists with Oz du Soleil
- On the Purple Frog Systems blog, Callum Bryant (@PurpleFrogSys) covers Using Stored Procedure as a Power BI Source (with parameters)
- Rick de Groot (@Rickmaurinus) describes Creating SWITCH Statements in Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Using EXPAND and COLLAPSE in visual calculations
- Gilbert Quevauvilliers (@GilbertQue) writes Did you know you can create DAX measures directly in the Power BI Service using Visual Calculations
- Antriksh Sharma (@AntrikshShar) writes about Using DETAILROWS with WINDOW functions in DAX
- On the Power BI community blog, Albert H explains How to Filter similar Columns Based on Specific Conditions
- Also on the Power BI community blog, Azik X describes The use of Cartesian products in many-to-many relational tables
- Greg Deckler (@GregDeckler) discusses DAX Counterculture: Alternative Prospectives on DAX
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bas Dohmen (@HowToPowerBI) talks about The best way to add images from OneDrive & SharePoint in Power BI
- On the Learning Science YouTube channel, Learning Science talks about Different options for date slicers in Power BI
- Erik Svensen (@donsvensen) covers Power BI – Make sure the data label is visible in a bar chart
- Reid Havens (@HavensBI) talks about Multi-Line KPI Data Labels for Native Visuals in Power BI
- Chandeep Chhabra (@chandeep2786) explains How to Set Up a Drillthrough in Power BI
- Dr. S. Gomathi (@GomsTechtalks) covers Transforming Data into Decisions Leveraging AI Visuals in Power BI for Insightful Analytics
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) writes that Performance Flow by xVIZ is the best visual for Parent Child hierarchies In Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Kurt Buhler (@kurtbuhler) writes about Tabular Editor and Fabric Git integration
- On Acuity Training, Ben Richardson (@AcuityTraining) describes Implementing Row-Level Security In Power BI
- On the Power BI blog, Nirupama Srinivasan (@MSPowerBI) explains how to Deliver report Subscriptions to OneDrive and SharePoint (Preview)
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, Saveen Reddy (@MSPowerBI) announces Power BI April 2024 Feature Summary
- Miguel Félix covers Atualização Power BI abril 2024 [Portuguese]
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 261
- On the PowerPivotPro blog, Kristi Cantor (@cajuncody) discusses Getting Your Data Ready for CoPilot in Power BI: A Guide to Optimized Implementation
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.