Power BI Weekly
Issue #191 - 24th January 2023
A flurry of exciting announcements this week. Firstly, we've been told about the Public Preview of Power BI Dataset Scale-Out which is the last big discrepancy between AAS and Power BI Premium, enabling dynamic scaling based on live query processing demands. It also enables the decoupling of refresh scenarios from live user queries, meaning that neither is affected by the load caused by the other. Sticking to compute improvements, we've been told about some backup and restore improvements for large datasets near the size limit, enabling backups near the dataset size limit to be restored more easily, through the addition of a new forceRestore
option. Elsewhere, we've been told about the new Connected Excel Tables from Power BI feature in Public Preview, allowing us to generate "standard" Excel tables (i.e. not just PivotTables) connected to our Power BI data, which is a huge step towards making Power BI more accessible for all.
Moving on - and one for the admins out there - there have been some My workspace governance improvements released in Public Preview, which allows admins to assign themselves access to personal workspaces, as well the ability to lock personal workspaces to a specific capacity (which may be required for data residence reasons). Another feature that's landed is the ability to Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings. You read it right - actual Power BI Apps embedded within Teams, rather than just content from workspaces. So that's pretty cool. And finally, last (and probably least), we've been told about the On-premises data gateway December release - no updates here, other than compatibility with the latest version of Power BI Desktop.
🛠️ Data Prep
- Maxim Zelensky (@Hohlick) writes about Faster Than Joins! Power Query Record as Dictionary: Part 3
- Ben Gribaudo (@bgribaudo) writes about The Oldest Is Not Always the Minimum: Power Query Date-Based Values May Not Compare the Way You’d Expect
- Chris Webb (@cwebb_bi) discusses Understanding The “A cyclic reference was encountered during evaluation” Error In Power Query In Power BI Or Excel
- On the Power BI community blog, Pär Adeen write about Query Folding - Works better than what you might think
- Chandeep Chhabra (@chandeep2786) talks about Dynamic Query Referencing in Power Query
- Gaelim Holland (@_EnterpriseDNA) describes How To Build A Google News Aggregator In Power BI Using Python
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes How to Import Data in Power BI Using R
- On the MSSQLTips site, Temidayo Omoniyi (@mssqltips) explains how to Connect Power BI to Azure Data Lake Gen2 Storage for Reporting
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) covers Debugging DAX measures in Power BI
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describes CROSSJOIN DAX Function: Server Timings & Query Plan
- Bas Dohmen (@HowToPowerBI) discusses WINDOW Function in Action I Examples in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) talks about DAX Fridays #218: Window functions in DAX explained with example
- Greg Deckler (@GregDeckler) writes about Why You Should Take Advantage Of The DAX Table Constructor
- On the Power BI community blog, Nadim Abou-Khalil covers Power BI – Multiple Fact Tables
- Olivier Travers (@otravers) discusses Aggregation Options in Power BI and SQL Server Analysis Services
- Reid Havens (@HavensBI) discusses Power BI Model Documenter - New Updates & Upcoming Features (with Marc Lelijveld)
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) explains how to Extend your Power BI Reports with Analysis Services 2022 Data
- On the Power BI community blog, Ted Pattison (@TedPattison) highlights the upcoming Dev Camp session: Building Multi-language Reports for Power BI in 2023
📊 Report Authoring and Interactivity
- Sam McKay (@_EnterpriseDNA) explains how to Create Dynamic Visuals Based On Ranking In Power BI With DAX and explains How To Change Size Of Visual Based On Ranking Selection In Power BI Using DAX [2023 Update]
- Reid Havens (@HavensBI) talks about Improving the Data Bar for Tables in Power BI
- On the Learning Science YouTube channel, Learning Science covers the Text Search Slicer Custom Visual in Power BI
- Pat Mahoney (@mahoneypa) explains How to deal with a slow matrix visual in your Power BI report, explains How to troubleshoot a slow matrix/table visual in Power BI and provides A useful "play-taset" for learning and troubleshooting Power BI
- Patrick Leblanc (@GuyInACube) explains how to Allow users to Show and Hide columns in a Power BI Paginated report
- On the Enterprise DNA blog, Sue Bayes (@sue_bayes) covers SSRS Paginated Reports: Line Chart Tutorial
- On the Enterprise DNA blog, Alexandru Badiu (@BadiuAlexandru) walks through Providing Context In Power BI Reports
🚀 Deployment, Security and Operations
- On the Power BI blog, Ikechukwu Edeagu (@MSPowerBI) announces Connected Excel Tables from Power BI (Public Preview)
- Also on the Power BI blog, Kay Unkroth (@MSPowerBI) shares Announcing the Public Preview of Power BI Dataset Scale-Out
- Also on the Power BI blog, Rick Xu announces the My workspace governance improvement (Public Preview)
- Also on the Power BI blog, Wayne Pai announces the backup and restore improvements for large datasets near the size limit
- Also on the Power BI blog, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway December release
- Antriksh Sharma (@AntrikshShar) explains how to Publish Power BI reports using PowerShell Cmdlet
- On the RADACAD blog, Reza Rad (@Rad_Reza) blogs about PowerShell Cmdlets for Power BI: What is it? And Why should you care?, discusses Power BI REST API; What it is and Why it is Important and explains how to Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant
- Gilbert Quevauvilliers (@GilbertQue) explains How to restore large Power BI Premium Backup files
🌐 General
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) shares Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 215