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
- 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
- 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
- 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
- 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
- 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