Power BI Weekly Issue 168: 2nd August 2022
The Power BI 2022 Wave 2 Release Plan has recently been released, with exciting features such as Query scale-out for Premium, a Quick Creation SDK (to embed "quick create" authoring scenarios into custom apps), and Dataset authoring in the Power BI Service. Other than that, we've also been made aware of some Power BI Ideas site updates that will be coming in the near future, including improvements to the search experience and finding related ideas.
Elsewhere this week, Chris Webb has shown how to create Custom Queries For “Detect Data Changes” In Power BI Incremental Refresh, Bernat Agulló has described how to Build an arbitrary YOY% growth chart with zoom-out tooltips, and Matthew Roche has highlighted a lot of the superb Power BI guidance from the CAT of which you should definitely be aware.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) covers Custom Queries For “Detect Data Changes” In Power BI Incremental Refresh
- Ben Gribaudo (@bgribaudo) covers Custom Connectors: Native Query Support
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about What is Power BI Dataflow and why you should use it and on the RADACAD blog, writes Getting Started With Dataflow in Power BI – Part 2 of Dataflow Series
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) explains How to Get Data Using Python in Power BI
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) describes how to Import data using R in Power BI
- Lars Schreiber (@SchreiberLars) covers Excel-Tabellenblätter mit sich ändernden Namen importieren [German]
- Rick de Groot (@Rickmaurinus) blogs about The IN Operator in M / Power Query and describes The COALESCE Operator in M / Power Query
- On the Power BI community blog, Vijay Verma discusses List.RandomBetween function in Power Query Language M
- Scott Sewell (@ScottSewell) presents Power BI Dev Camp: Bringing Power BI into the Dataverse through the Magic of Synapse
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers VAR – DAX Guide
- Also on the SQLBI blog, Marco Russo (@marcorus) discusses Row Context – The Whiteboard #02
- Brian Julius (@_EnterpriseDNA) explains How To Split Columns By Delimiters In Power BI Using DAX
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bernat Agulló Roselló (@AgulloBernat) covers Building an arbitrary YOY% growth chart with zoom-out tooltips
- Patrick Leblanc (@GuyInACube) blogs about Discovering data within Power BI and quickly export
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) describes Power BI Dynamic X and Y Axis Using Groupings in Field Parameters
- Rajendra Ongole talks about Field Parameters in Power BI
- On the Learning Science YouTube channel, Learning Science covers Video in Power BI - A custom visual
- Mara Pereira (@datapears) describes Power BI Viz Tricks - Line chart target areas
- Hima Bindu Marri (@sivahimabindu) talks about Sparklines in Power BI
- On the Power BI community blog, Ray Wu describes Visualising 3D object within Power BI
- Gaelim Holland (@_EnterpriseDNA) explains How To Use Emojis In Power BI
- Ruth Pozuelo Martinez (@CurbalEN) talks about Blurred images in Power BI? Here is how to fix it.
- Reid Havens (@HavensBI) discusses Insights Unlocked using Conditional Formatting in Power BI (with Pragati Jain)
- Audrée Pellerin covers Uniformisez vos rapports Power BI et sauvez du temps [French]
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Marc Lelijveld (@MarcLelijveld) explains how to Add user to Power BI deployment pipeline using REST APIs
- Philipp Lenz (@lenz_philipp) describes Overview of the Power BI Datahub
- Reid Havens (@HavensBI) talks about Sensitivity Labels and the Microsoft Data Platform (with Heidi Hasting)
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes Power BI Shared Datasets: What is it, How does it work, and Why should you care?
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Kelly Kaye (@MS_KellyKaye) announces Join Kim Manis at the First-Ever Microsoft Power Platform Conference
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares some Power BI Ideas site improvement updates
- Matthew Roche (@SQLAllFather) writes about Power BI guidance from the CAT
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 232 - Power BI - 2022 Release Wave 2 Plan
- Mimoune Djouallah (@mim_djo) explains How an Open Source Power BI Desktop May Look like
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.