Power BI Weekly
Issue #89 - 15th December 2020
A flurry of announcements this week - where should I start... Right. Large model support in Power BI Premium is now generally availabile (GA), with new enhancements around the UI, multi-geo support and the bring-your-own-key capability. If you're using Premium and have large datasets - consider this solution. There are some new Admin APIs and added Service Principal authentication to make for better tenant metadata scanning to complement the new Azure Purview service (mentioned in last week's editorial). These APIs should be more performant, and the ability to authenticate as a service principal helps when Setting up Azure Purview for Power BI.
Otherwise, a lot of you will probably be happy to hear that Full report attachment for subscriptions for Power BI Premium reports now available (the only technical limitations being that the report needs to be 20 pages or less, and the full attachement size less than 25MB). The team has also announced the public preview of Microsoft Information Protection Sensitivity Labels in Power BI Desktop, helping you maintain greater control and transparency over the sensitivity of your reports. Finally, the new On-premises data gateway December 2020 update is now available which includes a new Azure Cosmos DB connector, along with some SAP SSO deprecation notices.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) discusses Capturing SQL Queries Generated By A Power BI DirectQuery Dataset
- Ben Gribaudo (@bgribaudo) describes Adding an Error Details Column in Power Query
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) talks about YTD Flags in Power Query
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Avoid filtering issues in Power Query, describes how to Import Google public datasets in Power BI and describes how to Change field types in one step in Power Query
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) explains how to Parse JSON data in a column using Power Query in Power BI
- On the Enterprise DNA blog, Melissa de Korte writes about Calendar Layouts To Tabular Format Using Power Query
- Barrett Studdard (@Data_Stud) blogs about Machine Learning with Python APIs and Power BI
- On the MSSQLTips site, Kenneth A. Omorodion covers Combining multiple files from multiple folders in OneDrive for Business in Power BI
- Matthew Peterson (@mattpetersonbi) talks about Loading Folders as Data Sources in POWER BI
🧩 Data Modeling
- Reid Havens (@HavensBI) presents Tabular Editor 3 with Daniel Otykier
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) covers DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)
- Kreimir Ledinski writes about Conditional formatting with Calculation Groups in PowerBI Matrix visual
- On the Power BI Community blog, Eyelyn Qin describes how to Calculate revenue based on exchange rate of RMB
- Chandeep Chhabra (@chandeep2786) discusses Allocation Calculations In Power BI
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX FRIDAYS BATTLE #192: HASONEFILTER vs HASONEVALUE vs ISFILTERED vs ISCROSSFILTERED
- Daniil Maslyuk (@DMaslyuk) covers Single-letter day and month names in Power BI
- On the Power BI community blog, Varun Jain writes a Multiple Currency Solution In Power Bi
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about Vendor Analysis In Inventory Management Dashboards and shares a Data Model Power BI For Inventory Management
🚀 Deployment, Security and Operations
- On the Power BI blog, Yaron Canari (@YaronCanari) announces new Admin APIs and Service Principal authentication to make for better tenant metadata scanning
- Also on the Power BI blog, Danny Kadyshevitch announces Microsoft Information Protection Sensitivity Labels in Power BI Desktop (Public Preview)
- Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes that the On-premises data gateway December 2020 update is now available
- Soheil Bakhshi (@biinsightnz) writes about Power BI Governance, Good Practices: Setting up Azure Purview for Power BI
- Patrick Leblanc (@GuyInACube) blogs about Handling deletes within Incremental Refresh in Power BI
- Adam Saxton (@GuyInACube) introduces Power BI Premium Gen2
- On the Blue Granite blog, Angela Henry (@SQLSwimmer) writes about More Power BI Premium Choices!
🌐 General
- On the Power BI blog, Kay Unkroth announces large model support in Power BI Premium General Availability (GA)
- Also on the Power BI blog, Christopher Finlan (@cmfinlan) writes that Full report attachment for subscriptions for Power BI Premium reports now available
- Adam Saxton (@GuyInACube) shares the Last roundup of 2020 with some great Power BI updates! (Roundup | Dec 14, 2020)
- Adam Saxton and Patrick Leblanc (@GuyInACube) writes about 🔴 Special end of year stream w/ Will Thompson (Dec 12, 2020) *Charity Stream*
- On the CSG Pro blog, Gregory Petrossian (@gregpetrossian) writes about Why Excel Needs Power BI to Solve Your Data Analysis Issues
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) writes about Power BI Architecture in a Data Solution
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) discusses The importance of knowing different types of Power BI users a governance approach
- Also on the RADACAD YouTube channel, Asanka Padmakumara (@asanka_e) presents at Auckland Power BI user group recording: Power BI Tools for an advanced Power BI developer
- Matthew Roche (@SQLAllFather) presents at Glasgow Data User Group presentation: Building a Data Culture with Power BI
- Paul Turley (@paul_turley) shares some Power BI Expert Resources
- Allison Kennedy shares The Twelve Days of Christmas: Are you on Santa's Naughty List? and writes Data Story of the Month: Student Reports
- On the Power BI community blog, Ted Pattison (@TedPattison) highlights the Power BI Dev Camp -Session 5: December 17th - Learn About Developing for Power BI with React.js