Power BI Weekly
Issue #222 - 29th August 2023
This week we've got a handful of interesting announcements. The first being the public preview of automatic scaling for dataset scale-out which is another (the last?) feature bringing functional parity with Azure Analysis Services. Great news for large scale deployments. We've also been told about the new ways to create connected tables in Excel connected to Power BI, and been given a Heads up: Changes to Excel workbook support in Power BI workspaces where we've been made aware of the deprecation of certain features for Excel workbooks in Power BI workspaces - do check it out to see if it impacts your org's workflows. Diverging slightly, but sticking on the Excel theme, you must have seen the announcement around Python in Excel? I think this is a great feature, allowing people the flexibility to choose which familiar tool to use for the particular job at hand. It also enables more advanced visualizations, with popular charting libraries like matplotlib and seaborn being available by default. Exciting stuff.
Finally, continuing his tech-leader focussed Microsoft Fabric series, my colleague Barry has written about Exploring Strategies Enabled By Microsoft Fabric, using Wardley Maps as a tool to build situational awareness and visualize the evolution of disciplines and technology.
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) writes about Privacy Levels in Dataflows: Impacted by Staging?
- Chris Webb (@cwebb_bi) discusses Understanding The “External table is not in the expected format” Error In Power Query In Power BI And Excel
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) blogs about Power Query Google Sheets Connector: Explained + Examples
- Marc Lelijveld (@MarcLelijveld) describes how to Access OneLake files from Power BI Desktop
- Chandeep Chhabra (@chandeep2786) explains How to Learn M Language in Power Query | A Comprehensive Guide with 5 Structured Ideas
- On the phData blog, Zac Zinda explains How to Change Data Sources in Power BI
- On the Learning Science YouTube channel, Learning Science writes about AI for Identifying Images in Power BI - Just in Few Clicks Vision in Power BI
- Avi Singh (@powerbipro) shares a Power BI Ultimate Calendar Table / Date Table
🧩 Data Modeling
- On the Power BI community blog, Andrei Khaidarov writes about Unlocking the Power of RANKX: A Deep Dive into DAX Ranking
- On the MSSQLTips site, Nai Biao Zhou covers Learning DAX in Excel: A Step-by-Step Tutorial for Beginners
- Patrick Leblanc (@GuyInACube) explains how to Get your measures organized in Power BI
- Adam Saxton (@GuyInACube) describes Power BI has Copilot already? For DAX it does!
- On the phData blog, Spencer Baucke (@JSBaucke) talks about Creating a Measures Table in Power BI
- Antriksh Sharma (@AntrikshShar) describes how to Create Partitions in SSAS Tabular with Tabular Editor
📊 Report Authoring and Interactivity
- Kurt Buhler (@kurtbuhler) describes How to set table or matrix column widths in a Power BI report
- Chandeep Chhabra (@chandeep2786) explains How to Create a Project Overlapping Timeline Dashboard in Power BI
- Andrzej Leszkiewicz (@avatorl) talks about Revolution in Power BI data visualization. Highly customized charts based on native matrix visuals.
🚀 Deployment, Security and Operations
- On the Power BI blog, Kay Unkroth (@MSPowerBI) announces automatic scaling for dataset scale-out public preview
- Also on the Power BI blog, Nikki Waghani (@NikkiWaghani) highlights the On-premises data gateway August 2023 release
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes Moving from PBIRS to PBI Service reports thanks to SimplePBI and SwaggerAPI
- Wolfgang Strasser (@wstrasser) covers Testing Power BI row-level-security (RLS) got some improvements
- Kevin Chant (@kevchant) writes about Initial Microsoft Fabric Git integration tests for Power BI Reports
- Soheil Bakhshi (@biinsightnz) discusses Integrating Power BI with Azure DevOps Git, part 2: Local Machine Integration
- On the phData blog, Gavin Pedersen (@gavin_PD) describes How to Create a Power BI Workspace App
- Marc Lelijveld (@MarcLelijveld) discusses Unveiling Tenant Configuration in Fabric: Empowering User Exploration
- On the SQLBI blog, Marco Russo (@marcorus) talks about Managing hierarchical organizations in Power BI security roles
- Gilbert Quevauvilliers (@GilbertQue) discusses Part 2 – Storing the Log Analytics Queries in Azure Blob Storage (Power BI Query Usage and Performance Series)
- On the Purple Frog Systems blog, Nick Edwards (@PurpleFrogSys) explains how to Automate Power BI single table refresh using Azure Synapse Analytics and Power BI APIs
- Also on the phData blog, Chaitanya Uday Kulkarni and Manish Garg describe How to Migrate Paginated Reports SSRS to Power BI Service with Snowflake
🌐 General
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses the Power BI Certification: Everything You Need to Know
- Purna (Chandoo) Duggirala (@r1c1) shares CP03: The Ugly Truth About Power BI (actually, 4 of them)
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces new ways to create connected tables in Excel connected to Power BI and shares a Heads up: Changes to Excel workbook support in Power BI workspaces
- Sam McKay (@_EnterpriseDNA) talks about the Old Way vs New Way - Power BI, Excel, and Code Interpreter