Power BI Weekly Issue 130: 19th October 2021
Welcome to the 130th edition of Power BI Weekly! A handful of announcements this week. First of all, we've been told about the Power BI Desktop Installer Changes & WebView2, which includes an action on everyone who's installed Power BI Desktop via the Microsoft Store to install the new WebView2 rendering engine - see the blog for the link to the installer. We've also been told about the Power BI Streaming Dataflows October Update, including support for Azure Blob Storage as a source and support for static reference data to complement your streaming data. And last but not least, the Power BI October 2021 Feature Summary has been released, with my particular favourite this time being the further improvements to DirectQuery for Power BI datasets and Azure Analysis Services, whereby you can now select the specific tables you want to connect to.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) describes Handling "Select All" For Slicers Bound To Dynamic M Parameters In Power BI
- Erik Svensen (@donsvensen) explains How to avoid a rename step in PowerQuery when you use Table.FromList – PowerBI
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) blogs about Power Query Functions, Keywords, And Identifiers and Power Query Language Flow Best Practices
- Rick de Groot (@Rickmaurinus) explains how to Get Value from Previous Row using Power query, explains how to Create the Ultimate Date Table in Power Query incl Script and explains how to Remove Leading Zeros from Text in Power Query
- On the Power BI community blog, smpa01 describes Using JavaScript in power query for regex- Part2
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) provides 3 reasons to use views instead of tables in Power BI
- Bas Dohmen (@HowToPowerBI) discusses Combining Sheets with a Custom M Function in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) explains How to do Pagination without knowing the number of pages (Part 2) in Power Query | List.Generate
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes 7 reasons DAX is not easy, and shares a few tutorials: Currency – DAX Guide, Boolean – DAX Guide and Binary – DAX Guide
- Mimoune Djouallah (@mim_djo) discusses Model Header/Details Schema using Nested Data in BigQuery
- Adam Saxton (@GuyInACube) writes about When optimizing Power BI don't forget about CPU
- On the Towards Data Science blog, Salvatore Cagliari walks through Changing granularity of data in Power BI
- Reid Havens (@HavensBI) blogs about Adding Dynamic [DAX] Analytics Lines to Native Visuals in Power BI
- Hima Bindu Marri (@sivahimabindu) describes Variables in Power BI
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Getting the Most out of Power BI with Excel by Matt Allington
- On the Learning Science YouTube channel, Learning Science discusses the DAX ALL Function in Power BI
- On the SQL Shack blog, Aveek Das (@avikoleum) provides an Overview of Power BI Time calculations
- Alex J. Garcia (@AlexG_SmartPBI) writes about the Advanced Power BI Performance Analyser by SmartPowerBI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about the Search Bar in Power BI Slicer
- On the MSSQLTips site, Hristo Hristov describes Using Power BI Visualizations in Power Apps
- Sam McKay (@_EnterpriseDNA) presents a Power BI Freestyle Session
- David Abu describes Working with Filters in Power BI
- Meagan Longoria (@mmarie) blogs about Power BI, Maps, and Publish to Web
- Bas Dohmen (@HowToPowerBI) talks about Cohort Analysis in Power BI
- Marcus Wegener (@PowerBIler) writes Suchzeile in Power BI Datenschnitt [German]
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) talks about Inforiver – The Best Custom Visual in Power BI?
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Marc Lelijveld (@MarcLelijveld) describes Insights in Power BI dataset parameters and refresh schedule
- Patrick Leblanc (@GuyInACube) talks about RLS with Two Fact tables in Power BI
- Gilbert Quevauvilliers (@GilbertQue) covers Creating "Read" permissions on reports & datasets (Allowing to view datasets from remote apps)
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) writes about the Power BI Desktop Installer Changes & WebView2
- Also on the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) discusses the Power BI October 2021 Feature Summary
- Also on the Power BI blog, Mohammad Ali (@mohaali45) shares the Power BI Streaming Dataflows October Update
- Microsoft Power BI describes how to Track your business Goals on the go, from the Power BI Mobile app
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.