Power BI Weekly
Issue #219 - 8th August 2023
No official announcements related to Power BI this week. Chris Webb has shared with us a relatively new Power Query setting that has probably gone under the radar for most of us, and that's the ability to achieve Cross Database Query Folding For SQL Server Sources In Power Query In Power BI And Excel using a new EnableCrossDatabaseFolding
option. Elsewhere, Gilbert Quevauvilliers has shown how we can use Tabular Editor's "behind the scenes" functionality to our benefit in the blog Did you know you can use between when creating a New Group in Power BI? and Ted Pattison has presented another Power BI Dev Camp session - this one about Setting Datasource Credentials with the Power BI REST API. Finally, my colleague Barry has continued his technology leader-focused series with a useful comparison in the blog How Does Microsoft Fabric Measure Up To Data Mesh? and I've continued my Microsoft Fabric E2E demo series with the new video: Creating a OneLake Shortcut to ADLS Gen2. Do check these out!
🛠️ Data Prep
- Imke Feldmann (@TheBIccountant) explains how to Decode URI in Power Query with custom Uri.UnescapeDataString function
- Chris Webb (@cwebb_bi) describes Cross Database Query Folding For SQL Server Sources In Power Query In Power BI And Excel
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) writes about Artificial Intelligence Features in Power BI for Report Development - Part 2
🧩 Data Modeling
- Gilbert Quevauvilliers (@GilbertQue) writes Did you know you can use between when creating a New Group in Power BI
- On the SQLBI blog, Marco Russo (@marcorus) discusses Comparing different school terms in Power BI
📊 Report Authoring and Interactivity
- Bas Dohmen (@HowToPowerBI) describes Icon Slicer Buttons | Power BI Trick
- Reid Havens (@HavensBI) discusses Custom Data Labels, Curved Lines, and Leader Line Labels
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) share Power BI Bookmarks: The Ultimate Guide
- Also on the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about Power BI Default Slicer Value Explained
- Andrzej Leszkiewicz (@avatorl) discusses Choropleth Map? There is a better alternative and talks about Single Visual Power BI Dashboard | Real World Fake Data - HR Cross-Functional Mobility
- On the Learning Science YouTube channel, Learning Science explains How to display multiple values in one card in Power BI
- On the MSSQLTips site, Harris Amjad (@mssqltips) describes How to Use Custom Power KPI Matrix in Power BI Desktop
🚀 Deployment, Security and Operations
- Ted Pattison (@TedPattison) presents Power BI Dev Camp session 33 - Setting Datasource Credentials with the Power BI REST API
- Miguel Félix covers Power BI Developer Mode (parte 2 de 3) [Portuguese]
- Reid Havens (@HavensBI) presents Upgrading Power BI Architecture - Sharing, Gov, & Admin (with Steve Campbell)
- Meagan Longoria (@mmarie) writes about Creating and Configuring a Power BI VNet Data Gateway
- Wolfgang Strasser (@wstrasser) explains how to Create a Microsoft 365 Developer Sandbox (including 25 E5 Test users) to test Power BI (and Fabric too)
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe Power BI Sign In: How To Sign Up & Sign In
🌐 General
- Kurt Buhler (@kurtbuhler) covers Solve the Right Problems