Power BI Weekly
Issue #126 - 21st September 2021
Not much going on from the Power BI team this week, other than a pre-announcment regarding the Automatic Installation of the Power BI app for Microsoft Teams, with a new Power BI tenant setting being exposed should you (as an admin) not want that to happen. Elsewhere this week, Brian Julius has talked about the lesser-knownGreat New Hidden DAX Function - COLUMNSTATISTICS, which, unsurprisingly, provides statistics/metadata on every column of every table within your model. Great if you want to analyse column distributions and other information before creating stories/gaining other insights from the data. Patrick Leblanc has described How to show a name more than once in Power BI using a couple of methods, one of which uses additional metadata you can add to tables within your model (which you may not have seen before!) Finally, Fowmy Abdulmuttalib has described How to make Progress Circle and Bar Charts with Native Power BI Visuals, a great use case of how to use additional card visuals to your advantage when designing "custom" visualisations.
🛠️ Data Prep
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) shares a few blogs: Power Query Data Types And Connectors, Variables And Expressions Inside Power Query Editor, Power BI Values And Literals – Understanding The Basics and Record Values – Structured Value In Power Query
- Rick de Groot (@Rickmaurinus) discusses Date calculations: find the first Monday of the Next Month in Power Query and describes How to create a Journal Entry with Power Query
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) shares a Power Query Function | Column Value Distribution in Power BI and describes how to Change the Data Source type of the Power BI Dynamically using Power Query Parameters
- On the SQL Server Central blog, JerodJ describes how to Author Power BI Reports on Real-Time ServiceNow Data
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) provides a Deep dive into measure filters in Power BI Desktop, describes Checking Boolean conditions while creating a like for like comparison in DAX – Unplugged #36 and talks about SUBSTITUTEWITHINDEX – DAX Guide
- Patrick Leblanc (@GuyInACube) describes How to show a name more than once in Power BI
- On the Towards Data Science blog, Salvatore Cagliari talks about What's fancy about context transition in DAX?
- Parker Stevens (@PowerBIElite) explains How to Convert Timezones in Power BI
- Antriksh Sharma (@AntrikshShar) compares SUM vs SUMX in DAX
- Brian Julius talks about The Great New Hidden DAX Function Pt. 1 – Overview and Pt. 2 – Dynamic Analyses
- Matthew Peterson (@mattpetersonbi) writes about the Difference Between Related and RelatedTable
- Allison Kennedy covers Power BI Forecasting with irregular time periods
- Hima Bindu Marri (@sivahimabindu) describes how to Sync Slicers in Power BI Power BI for beginners
- David Abu explains how to Want to Create DAX Measures Faster? Use Quick Measures
- Dhruvin Shah (@DhruvinShah16) talks about Leading 0 before Numeric Value in Power BI and provides an Introduction to Calculation Group in Power BI
- Andrzej Leszkiewicz (@avatorl) describes how to Backup/restore all calculation groups (workaround required for some visuals)
📊 Report Authoring and Interactivity
- Fowmy Abdulmuttalib (@ExcelFort) describes How to make Progress Circle and Bar Charts with Native Power BI Visuals
- Allison Kennedy writes a Visual Review: Area Chart and writes about Tooltips in Power BI
- Bas Dohmen (@HowToPowerBI) describes a Custom KPI Card in Power BI and discusses the Azure Maps Visual in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Create beautiful progress bars without custom visuals and explains how to Create stunning reports with less effort with this setting | Custom Backgrounds
- Reid Havens (@HavensBI) blogs about Using Shadows to Frame Border Objects in Power BI
- Sam McKay (@_EnterpriseDNA) explains How To Dissect Someone Elses Power BI Report - Learn How It Works
🚀 Deployment, Security and Operations
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) pre-announces the Automatic Installation of the Power BI app for Microsoft Teams
- Chris Webb (@cwebb_bi) writes about Why You Should Optimise Your Power BI Premium Reports And Refreshes For CPU Time As Well As Duration
- Gilbert Quevauvilliers (@GilbertQue) describes How to connect to a Power BI Premium Per User using SQL Profiler
🌐 General
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (September 18, 2021)
- Matt Allington (@ExceleratorBI) talks about What does the Data Say?
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about Power BI and Synapse, Part 2: What Synapse brings to a table
- Jeroen ter Heerdt (@jeroenterheerdt) walks through Visualizing Home Assistant data in Power BI