Power BI Weekly
Issue #157 - 17th May 2022
Yesterday the Power BI May 2022 Feature Summary came out, and the feature that's drawn the most attention (quite rightly) has been the introduction of Field parameters, for a much more seamless way of allowing users to dynamically change the measures/fields shown on a chart. Other news this week includes the new ability for tenant admins to disable DirectQuery against Power BI Datasets (although I do sympathize if your tenant admin decides to do this), and that the Charticulator visual is now GA. We've also been told about some SandDance Power BI Custom Visual updates, the new Action bar for interactive reports in the Power BI tab for Microsoft Teams and the New Power BI Known Issue page. On that last point, Gilbert Quevauvilliers has created and demonstrated a helpful Known Issues Power BI Report with Alerting.
Elsewhere this week, James Serra has broken down the various Power BI connectors to Azure Synapse, Jess Hill has written about Table Functions in DAX: FILTER and ALL, and Ignacio Barrau has shared a new external tool which generates a handy Data Quality Report over an existing data model.
🛠️ Data Prep
- Imke Feldmann (@TheBIccountant) explains how to Create (empty) table string from schema in Power Query
- Hima Bindu Marri (@sivahimabindu) covers Query folding in Power BI Part 1
- On the Power BI community blog, Vijay Verma describes how to Test for a Number in Power Query M Language
- James Serra (@JamesSerra) blogs about Power BI connectors to Azure Synapse
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) describes how to Import data using Python in Power BI
🧩 Data Modeling
- On the endjin blog, Jessica Hill describes Table Functions in DAX: FILTER and ALL
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Understanding context transition, describes PERMUT – DAX Guide and discusses DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD – DAX Guide
- Bas Dohmen (@HowToPowerBI) shares a few videos: Filter Context & CALCULATE | DAX Essentials 1, Row Context & Iterators | DAX Essentials 2 and Context Transition | DAX Essentials 3
- Patrick Leblanc (@GuyInACube) talks about Why isn't my Agg hitting when using DISTINCTCOUNT in Power BI?
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) covers Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX and talks about Using DataTable DAX Function for Creating Structured Table in Power BI
- On the Learning Science YouTube channel, Learning Science describes Virtual Table and SUMMARIZE Function in Power BI
- Avi Singh (@powerbipro) discusses Power BI: Year to Date Comparison for Current vs. Prior Year
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about Three things you need to know when using Variables in DAX
- Jing Zhang describes how to Group your data according to dynamic measure results
- Reid Havens (@HavensBI) shares DAX Anti-Patterns Episode Nine - Filter Columns Not Tables! (Part 1) - with Daniil Maslyuk
- Also on the Towards Data Science blog, Nikola Ilic (@DataMozart) writes In the Power BI whirlpool — understanding circular dependencies
📊 Report Authoring and Interactivity
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) announces the SandDance Power BI Custom Visual updates
- On the Power GI blog, Danni Olson covers Story Telling with PowerBI
- James Andrew describes Using Power BI Template Files for Great Data Visualization
- Gilbert Quevauvilliers (@GilbertQue) shares a Known Issues Power BI Report with Alerting
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) provides a Power BI Report Builder Introduction
- On the MSSQLTips site, Scott Murray describes Power BI Desktop - What is it and how do I use it?
- Michael Felix describes Algumas funcionalidades [Portuguese]
- James Andrew describes Essential Keyboard Shortcuts in Power BI Desktop | #shorts #data
🚀 Deployment, Security and Operations
- On the Power BI blog, Roy Rubinstein announces the New Power BI Known Issue page
- Patrick Leblanc (@GuyInACube) describes How do you share your Power BI Dataset for someone to review?
- Reid Havens (@HavensBI) discusses Let Me Sell You on Power BI Goals (with Tommy Puglia)
🌐 General
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares the Power BI May 2022 Feature Summary
- Also on the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces the Action bar for interactive reports in the Power BI tab for Microsoft Teams
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 224 - Power BI April 2022 Feature Summary
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) presents Live Power BI Q&A with RADACAD - 2022-05-13
- Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show Ep 4 - Incremental Refresh, Hybrid Tables, and Charticulator
- Ignacio Barrau (@ignacho_07) announces Data Quality Report - Power BI external tool [Spanish]
- On the Power BI community blog, Ted Pattison (@TedPattison) announces Deep Dive into Power Query and M Programming at Power BI Dev Camp