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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On Acuity Training, Ben Richardson (@AcuityTraining) writes about Sharing Reports & Dashboards In Power BI
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 269 - Power BI November 2023 Feature Summary part 2
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.