Power BI Weekly
Issue #236 - 5th December 2023
This week there are a couple of official Power BI-related blogs - one of which is announcing that we can now Read data from Delta Lake tables with the DeltaLake.Table M function (woohoo), and the other has given us a Deep dive into the new DAX query view and writing DAX queries. Elsewhere, the Tabular Editor team has shared their summary of the Tabular Editor 3: November 2023 Release for those using that tool, which includes the ability to save measures embedded within a DEFINE block of a DAX query, and includes other improvements such as highlighting unused DAX variables. Finally, Bernat Agulló is back with a blog describing how you can Detect selection on field parameters and calculation groups.
🛠️ Data Prep
- On the Power BI blog, Chris Webb (@cwebb_bi) described how to Read data from Delta Lake tables with the DeltaLake.Table M function and, on his personal blog, writes about Anti Joins And Query Folding In Power Query In Excel And Power BI
- On the Power BI community blog, Alexis Olson describes Sharing Power Query tables
- On the Learning Science YouTube channel, Learning Science describes How to bring a column from one table to another table in Power Query?
- Ignacio Barrau (@ignacho_07) covers [Fabric] Nuevo tipo de conexión - Direct Lake [Spanish]
🧩 Data Modeling
- On the Power BI blog, Zoe Douglas (@MSPowerBI) writes a Deep dive into DAX query view and writing DAX queries
- Reid Havens (@HavensBI) talks about Visual Calculations – Making [DAX] Easier (with Jeroen ter Heerdt)
- On the Tabular Editor blog, Daniel Otykier (@DOtykier) announces Tabular Editor 3: November 2023 Release
- Bernat Agulló Roselló (@AgulloBernat) describes Detecting selection on field parameters and calculation groups
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) describes Going the Next Step with Stock Measures in DAX
- Chandeep Chhabra (@chandeep2786) talks about Tricky Snowflake Schema Calculations in Power BI | A Step-by-Step Guide
- On Acuity Training, Ben Richardson (@AcuityTraining) covers Using The Group By Feature In Power BI, describes How To Create Data Models in Power BI and walks through Working With Date Formats In Power BI
📊 Report Authoring and Interactivity
- Erik Svensen (@donsvensen) explains how to Create a dynamic slicer with field parameters with core visual
- On the MSSQLTips site, Harris Amjad (@mssqltips) describes Area Chart in Power BI to Understand Data Changes Over Time
- Reid Havens (@HavensBI) walks through Introducing Inforiver Analytics+ (Charts+Cards+Tables) in Power BI (with Gopal Krishnamurthy)
- Soheil Bakhshi (@biinsightnz) blogs about Microsoft Fabric: Generating Reports with Copilot
- On Acuity Training, Ben Richardson (@AcuityTraining) describes How To Create Scatter Charts In Power BI, blogs about Using The Decomposition Tree Visual In Power BI, walks through Creating Gantt Charts In Power BI, describes How To Use The Smart Narrative Visual In Microsoft Power BI, describes Creating A Combo Chart Two-Axis Chart In Power BI, describes Creating A Bullet Chart In Power BI and blogs about Creating A Word Cloud In Power BI
- Carl de Souza (@carldesouza) writes about Embedding a Dataverse Canvas App Inside Power BI Reports
🚀 Deployment, Security and Operations
- On Acuity Training, Ben Richardson (@AcuityTraining) writes about Sharing Reports & Dashboards In Power BI
🌐 General
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 269 - Power BI November 2023 Feature Summary part 2