Power BI Weekly
Issue #251 - 26th March 2024
Move aside SQLBits, it's FabCon week this week, and there have already been some huge announcements on the Fabric side to sink your teeth into. Grab a drink and take a read of Arun's all-encompassing blog here: Announcements from the Microsoft Fabric Community Conference to get an overview of all the new and updated features. A few of the bigger ones being that Mirroring is supported in Public Preview (for Cosmos DB, Azure SQL DB and Snowflake), you can now access on-premises data using the on-premises Data Gateway in Data Factory pipelines, and you can have Folders in the Workspace View! More specifically to Power BI, we've also been given the Power BI March 2024 Feature Summary, which mainly comprises a handful of incremental improvements/updates to existing features.
Elsewhere this week, Patrick Leblanc has shared a video about Decoding Direct Lake: The Truth Behind DirectQuery Fallback, Paul Turley has written a great blog around Moving from Power BI to Microsoft Fabric, and Erik Svensen has shown a clever way to Combine visual calculations and numeric parameters to create a dynamic moving average period.
Finally, Barry has written a great blog reflecting on SQLbits 2024 - The Best Bits (whereby I'm only now realising just how many photos the man takes). All in all, it was a wonderful conference, wonderfully run with wonderful people. Hope to see you there next year!
🛠️ Data Prep
- Adam Saxton (@GuyInACube) describes How to connect to Microsoft Fabric Items from Power BI Desktop?
- Patrick Leblanc (@GuyInACube) discusses Decoding Direct Lake: The Truth Behind DirectQuery Fallback
- Chris Webb (@cwebb_bi) talks about Best Practices For Power BI On Databricks Webinar
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Vpax Obfuscator and DAX Optimizer – Unplugged #57
- On the SQL Server Central blog, Koen Verbeeck (@Ko_Ver) explains How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer
- Chandeep Chhabra (@chandeep2786) describes How to Perform VLOOKUP in Power BI and talks about Who bought A but not B? . . . (Pattern Analysis in Power BI)
📊 Report Authoring and Interactivity
- Erik Svensen (@donsvensen) delves into Power BI – Combine visual calculations and numeric parameters to create a dynamic moving average period
- Also on the Learning Science YouTube channel, Learning Science explains How to calculate moving average at visual level in Power BI without using complex DAX measure
- Andrzej Leszkiewicz (@avatorl) covers HTML/CSS in core Power BI visuals
- Reid Havens (@HavensBI) describes Turning Beast to Beauty: Removing Chart Junk in Power BI
🚀 Deployment, Security and Operations
- Chris Wagner (@KratosBi) describes Everything About Power BI Security
- Philipp Lenz (@lenz_philipp) writes about Dynamic subscriptions with email in Power BI – Part 1
- Nikil Prabhakar wonders Is Data Activator ready for Prime Time?
- Ignacio Barrau (@ignacho_07) covers [Fabric] Data Activator - Triggers y alerta instantánea [Spanish]
🌐 General
- On the Power BI blog, Saveen Reddy (@MSPowerBI) shares the Power BI March 2024 Feature Summary
- Paul Turley (@paul_turley) walks through Moving from Power BI to Microsoft Fabric