Power BI Weekly
Issue #238 - 19th December 2023
This will be the final edition of 2023 as we wind down for our holiday season here at endjin. And going by the size of this edition, lots of others are also winding down - so a good time to pause. We'll be back at the start of January with an edition covering everything from today onwards.
In the last week we've received the Power BI December 2023 Feature Summary. First thing to note is that it seems like the "delayed build" they refer to at the top of the blog is now available - there seems to have been new Power BI Desktop version published yesterday, and I think a new version may already be available in the Microsoft Store. Anyway, the main features/updates in this month's release is that there are new styling options for column and bar charts, alongside some new customization options for data labels. There's also a new OneLake data hub in Power BI Desktop where you'll now find Power BI datasets and Datamarts, as well as Fabric Lakehouses, Warehouses and KQL Databases. No original Dataflows though - that's hidden under more options.
Elsewhere this week, and to continue from his announcement about the new Delta Lake tables M function, Chris has discussed how you can use this functionality to perform Incremental Refresh On Delta Tables In Power BI - regardless of whether you're using Fabric to generate those tables or some other tool.
That's where I'll leave it for this week, and this year. Thanks to all of our readers for following this newsletter; I hope you'll stick around for another year of weekly Power BI updates. Happy holidays for those that celebrate - see you on the other side!
🛠️ Data Prep
- Chandeep Chhabra (@chandeep2786) describes The Ultimate Power Query Wrapping Shortcut and explains How to Fix Pivoting Errors in Power Query
🧩 Data Modeling
- Patrick Leblanc (@GuyInACube) talks about Create a measure from a filtered visual in Power BI?
- Reid Havens (@HavensBI) discusses Demystifying [DAX] Evaluation Context (with Brian Grant)
- Soheil Bakhshi (@biinsightnz) describes how to Microsoft Fabric: Use Copilot to Generate Data Model Synonyms
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) writes about New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables
- Morten Lønskov shares the Tabular Editor 3: December 2023 Release
📊 Report Authoring and Interactivity
- Bas Dohmen (@HowToPowerBI) describes how to Build a Native Dumbbell Chart in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes Data Storytelling | Right Chart Selection Example | Actual (Revenue) vs. Forecast
- Reid Havens (@HavensBI) talks about Improved - IBCS Styled Bullet Charts (SVG) in Power BI (with Daniel Marsh-Patrick)
- On the Learning Science YouTube channel, Learning Science describes How to add help text for Power BI visuals? | Help text tool tip for Power BI visuals
🚀 Deployment, Security and Operations
- Chris Webb (@cwebb_bi) writes about Incremental Refresh On Delta Tables In Power BI
- On the SQL Server Central blog, Dennes Torres (@Dennes) writes about Source Control with GIT, Power BI and Microsoft Fabric
🌐 General
- On the Power BI blog, Saveen Reddy (@MSPowerBI) announces the Power BI December 2023 Feature Summary
- Miguel Félix covers Atualização Power BI dezembro 2023 [Portuguese]
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 248
- On the MSSQLTips site, Amira Bedhiafi (@AmiraBedhiafi) writes about the Most Overlooked Features in Power BI
- Sam McKay (@_EnterpriseDNA) describes Using ChatGPT To Supercharge Power BI Development