Power BI Weekly
Issue #152 - 12th April 2022
A handful of updates this week: there are some new gateway security roles for Power BI, there have been some improvements to the management of Power BI subscriptions, you can now Detect upload of sensitive information to Power BI using Microsoft 365 data loss prevention policies, and there has been a pre-announcement that the Automatic Installation of the Power BI app for Microsoft Teams is expanding to Active users.
Elsewhere this week, Jess Hill has written a nice blog comparing Measures vs Calculated Columns in DAX and Power BI (an often confusing topic when starting out with DAX), Ben Gribaudo has described how to Combine Query String Parameters—a.k.a. Inclusive Record Field Combining, and Mathias Thierbach has presented a brilliant three-part demo of pbi-tools on Reid Havens' channel, showing how you can use the OSS toolset to handle your Power BI ALM/version control needs. See the videos here:
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) describes Combining Query String Parameters—a.ka. Inclusive Record Field Combining
- On the Power BI community blog, Vijay Verma describes How to see full cell content in Power Query Editor, writes about Text.ExcelTrim function in Power Query M Language and discusses Finding First/Last non null value in a row in Power Query M Language
- Rick de Groot (@Rickmaurinus) explains How to Extract a Date From Text in Power Query
- Chandeep Chhabra (@chandeep2786) describes 5 Ways to Create a Date in Power Query
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes how to Correct the Incorrect Different Dates Formats via Power Query | 30 Mins to 5 Seconds Solution
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes Extracting Data from Nested Lists and Records in Power Query
- Fowmy Abdulmuttalib (@ExcelFort) talks about Budget Allocation With Seasonality In Power BI | Step By Step Tutorial
- On the PowerPivotPro blog, Kristi Cantor (@cajuncody) blogs about Solving the Query – Pivot Edition
- Amit Chandak (@amitchandak78) presents Power BI Abstract Thesis Episode 62: Split Column and Combine Columns
🧩 Data Modeling
- On the endjin blog, Jessica Hill discusses Measures vs Calculated Columns in DAX and Power BI
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes RANKX – DAX Guide and describes SAMPLE – DAX Guide
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) covers Total Sales based on Dates Between & Excluding Weekends and Holidays in Power BI | CALCULATE DAX
- Avi Singh (@powerbipro) covers Power BI: How to Show Headcount Data for Latest Month (Question & Answer)
- Bas Dohmen (@HowToPowerBI) describes Building a Financial Statement with Calculation Groups in Power BI
- Bernat Agulló Roselló (@AgulloBernat) writes about Completely arbitrary tables in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses Power BI What If Parameter For Data Models
- Ruth Pozuelo Martinez (@CurbalEN) describes Good KPIs, Bad KPIs and the north star metric | A Power BI Goals pre-guide
- Mark Walter (@markwaltercpa) describes how to Insert Custom Subtotals in the Matrix Visual
📊 Report Authoring and Interactivity
- James Andrew walks through Importing Custom JSON Icons into Power BI | Improve Your Conditional Formatting
- Ruth Pozuelo Martinez (@CurbalEN) talks about Custom KPI icons in Power BI
- Bas Dohmen (@HowToPowerBI) discusses Colour Banding in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes how to Change Visual with Bookmark Buttons in Microsoft Power BI
- On the Learning Science YouTube channel, Learning Science describes how to Dynamically change chart axis values in Power BI - Simple Trick
- Patrick Leblanc (@GuyInACube) covers Nothing selected in Power BI Slicer? Then don’t show data!
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) covers Power BI Design Tip: Design for Mobile Device
- On the Burningsuit blog, Stuart Box (@StuartBox) announces Our Book – Introducing Charticulator for Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Miquella de Boer (@MSPowerBI) announces Additional gateway security roles for Power BI
- Also on the Power BI blog, Michael Bruhjell (@MSPowerBI) announces Managing Power BI subscriptions just got easier
- Also on the Power BI blog, Anton Fritz (@AntonFritz15) announces Detect upload of sensitive information to Power BI using Microsoft 365 data loss prevention policies
- Philipp Lenz (@lenz_philipp) explains how to Deploy Power BI Paginated Reports with Azure DevOps in a Continuous Deployment scenario
- Chris Webb (@cwebb_bi) highlights the New Book: “Microsoft Power BI Performance Best Practices” By Bhavik Merchant
- Henry Habib and Tim Weinzapfel (@_EnterpriseDNA) explain How To Automatically Send Emails By Linking Power BI And Power Automate
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 20 - Scaling Multi - tenant Solutions using Service Principal Profiles
- Dhruvin Shah (@DhruvinShah16) describes how to Monitor Dataflow Refresh History using Power BI Dashboard
- Reid Havens (@HavensBI) discusses PBI-Tools Part 1 - Introduction and Setup (with Mathias Thierbach), delves into PBI-Tools Part 2a - Create a GitHub Actions Workflow (with Mathias Thierbach) and talks about PBI-Tools Part 2b - Creating an Azure DevOps Pipeline (with Mathias Thierbach)
🌐 General
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces Pre-announcing Automatic Installation of the Power BI app for Microsoft Teams is expanding to Active users
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) covers Power BI vs SSRS