Power BI Weekly
Issue #234 - 21st November 2023
You'll probably be aware that last week was the Microsoft Ignite conference, which was, well - eventful! If you missed it, here's the Book of news, and all the sessions can be streamed on-demand now. Naturally, the main news in the analytical space was the GA of Microsoft Fabric workloads, which came alongside a swathe of announcements that can all be found on the Microsoft Fabric blog. One of the main new features being that of Mirroring (which was originally highlighted in Arun's blog Prepare your data for AI innovation with Microsoft Fabric) which replicates your database data (from its proprietary format) into Delta tables in Fabric. So, like shortcuts but to your database data. Pretty cool, but (as is a bit of a theme with Fabric announcements) it's not available to use yet - you have to apply for the early adopter programme.
More specifically to Power BI, Kim Manis shared the blog: Empower Power BI users with Microsoft Fabric and Copilot giving a summary of the main Power BI-related announcements. On the Copilot front, you'll have probably seen the videos from Microsoft Build earlier this year where Copilot automatically creates full reports for you, including measures, chart design, Smart Narratives (now re-branded as "Narrative with Copilot") etc. Unfortunately this is initially only available to those using P1/F64 or above SKUs, and is being rolled out in stages lasting until March 2024. We've also been told about the support for Direct Lake on Synapse Data Warehouses (woohoo), the integration of import-mode semantic models with OneLake, and many other announcements.
If that wasn't enough, we've also been given the Power BI November 2023 Feature Summary, which includes information about the New button slicer, the New card’s reference labels and the new Explore feature, all in Public Preview. As ever, this update comes alongside a walkthrough video, which you can find here: Power BI Update - November 2023 if you'd rather sit and watch!
🛠️ Data Prep
- Reid Havens (@HavensBI) describes how to Automatically Rename CamelCase Columns in Power Query
- Miguel Félix covers Conetividade no Power Query [Portuguese]
🧩 Data Modeling
- Chris Webb (@cwebb_bi) shares some Thoughts On Power BI Datasets Being Renamed To Semantic Models
- Kurt Buhler (@kurtbuhler) writes about Semantic models in simple terms
- Sandeep Pawar (@PawarBI) describes Identifying Semantic Model Storage Mode in Fabric
- On the SQLBI blog, Marco Russo (@marcorus) talks about Unboxing DAX Query View in Power BI – Unplugged #54
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) describes Good to Know: Copilot in Power BI
- On the Learning Science YouTube channel, Learning Science Shares Explain about Bidirectional Cross-Filtering in Power BI, SUM vs SUMX function in Power BI & DAX and 3 Months Rolling Total in Power BI | How to calculate 3 months rolling total in Power BI
- Chandeep Chhabra (@chandeep2786) describes How to Use Excel's Like SUMIF and COUNTIF in Power BI
📊 Report Authoring and Interactivity
- On the Power BI blog, Miguel Myers (@myersmiguel) announces the New button slicer | Public preview and the New card’s reference labels | Public preview
- Also on the Power BI blog, Roseanne Levasseur (@MSPowerBI) announces Introducing Explore (Public Preview)
- Reid Havens (@HavensBI) talks about VisOps with PBI Inspector (with Nat Van Gulck)
- Bas Dohmen (@HowToPowerBI) explains how to Add SVG Images in Power BI, discusses Trend Visualization in Power BI and talks about Quick GIF for your Power BI report | Adding animations in Power BI
🚀 Deployment, Security and Operations
- On the RADACAD blog, Reza Rad (@Rad_Reza) blogs about Version Control in Power BI and Fabric
- Bernat Agulló Roselló (@AgulloBernat) discusses Orchestrating Dataset Refreshes with Power Automate and Power Apps (Part 2)
- Adam Saxton (@GuyInACube) presents Digging deeper into Data Activator in Microsoft Fabric with Will Thompson
🌐 General
- On the Power BI blog, Ryan Majidimehr (@MSPowerBI) announces Power BI November 2023 Feature Summary
- Miguel Félix covers Atualização Power BI novembro 2023 [Portuguese]
- Also on the Power BI blog, Kim Manis (@kimmanis) announces Empower Power BI users with Microsoft Fabric and Copilot
- Microsoft Power BI (@MSPowerBI) share Power BI Partner Opportunities Expand with Microsoft Fabric
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 267 - Microsoft Ignite 2023 - Fabric is GA
- Fowmy Abdulmuttalib (@ExcelFort) walks through Unlocking Revenue Insights: Power BI Launch-to-Date Performance Analysis