Power BI Weekly
Issue #60 - 26th May 2020
For those of you that don't know, it was the first fully virtual Microsoft Build conference last week. Some huge announcements across the board, having implications in both the Azure and Power BI ecosystems. If you want to catch up on all the Azure announcements, check out the latest edition of Azure Weekly. Arguably the biggest announcement of them all, is the Azure Synapse Analytics public preview, a powerful end-to-end analytics platform with Power BI built right into it - read about 5 Reasons why Azure Synapse Analytics should be on your roadmap. Otherwise, we've been told about the General Availability of shared and certified datasets in Power BI, which introduces the new "force delete" functionality for dataset owners, whereby all dependent reports will either be deleted or disconnected from their data model (depending on whether the report resides in the dataset's workspace or a different workspace).
A few Premium announcements this week: there is a new Refresh Summary UI and corresponding REST API, which gives the premium capacity's admins an overview of all scheduled refreshes activity on their premium capacity. We've also been told that the Metrics App is now available as a template app, and that service principals using the XMLA endpoint are now supported.
Elsewhere, the Power BI Desktop May 2020 Feature Summary has been shared with us, including featured tables for Excel, the GA of the decomposition tree, and the new Apply All filters button for the filter pane. Finally, the May On-premises data gateway update is now available.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) describes Monitoring Power Query Memory Usage With Query Diagnostics In Power BI and describes how to Limit The Amount Of Data You Work With In Power BI Desktop Using Parameters And Deployment Pipelines
- On the Power BI community blog, Allison Kennedy describes how to Use Parameters to Combine Data
- Also on the Power BI community blog, David Gerard blogs about Data Types, Data Formats, and Data Category
- Parv Chana (@parvchana) explains how to Transform Data in Power Query using the Unpivot and Pivot Functions
- Jon Acampora (@excelcampus) explains How to Combine Tables with Power Query
- Dustin Ryan (@SQLDusty) blogs about Power BI Incremental Refresh with Web API Data Source
- Erik Svensen (@donsvensen) writes about Incremental refresh in Power BI with data from BigQuery
- On the Purple Frog Systems blog, Alex Whittles (@PurpleFrogAlex) writes about a Power BI Databricks Spark connection error
🧩 Data Modeling
- On the Power BI community blog, Sam McKay (@_EnterpriseDNA) explains How and When to Create Virtual Relationships Using the TREATAS Function
- Also on the Power BI community blog, Greg Deckler (@GregDeckler) covers Thoughts and Details about The Mythical DAX Index
- Mimoune Djouallah (@mim_djo) describes How to Model Primavera Activity ID and Quantity Measurement System using Multiple to Multiple in PowerBI
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Using USERELATIONSHIP in DAX
- Also on the SQLBI blog, Marco Russo (@marcorus) writes about Standard DAX separators in Power BI Desktop and describes Query Performance Tuning in DAX Studio
- Also on the SQLBI blog, Marco Russo & Alberto Ferrari provide A proposal for visual calculations in DAX
- Chandeep Chhabra (@chandeep2786) explains how to Calculate Non Blank Values – DAX Tip
- Rafael Mendonça (@rafaelmpsantos) writes Você está com erro nas suas funções DAX que até ontem funcionavam?
⚙️ Report Design and Visualizations
- Patrick Leblanc (@GuyInACube) covers EVERYTHING you wanted to know about Power BI tooltips
- Parv Chana (@parvchana) explains how to Illuminate KPI cards with new shadow feature and conditional formatting
- Gilbert Quevauvilliers (@GilbertQue) describes How to fix Power BI Slicer Items that are not clickable because there are too many Visual Header Icons
- Adam Saxton (@GuyInACube) wonders Can you embed PowerPoint into a Power BI App? Lets try!
⚙️ Data Exploration
- Marc Lelijveld (@MarcLelijveld) explains how to Personalize your Power BI page navigation
- Daniil Maslyuk (@DMaslyuk) writes about Dynamic page navigation and drillthrough
🚀 Deployment, Security and Operations
- On the endjin blog, Ed Freeman (@edfreeman_) blogs about Power BI Embedded: Convention-based dynamic Row-level Security
- Matt Allington (@ExceleratorBI) writes about New Power BI Reports from a Golden Dataset
- On the Power BI blog, Kay Unkroth announces the General Availability (GA) of shared and certified datasets in Power BI
- Also on the Power BI blog, Swati Gupta introduces Power BI Premium Capacity Metrics App as a template app
- Also on the Power BI blog, Kay Unkroth announces support for service principals using the XMLA endpoint in Power BI Premium
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes that the On-premises data gateway May 2020 update is now available
- Also on the Power BI blog, David Magar announces Refresh Summary for Premium Capacity Admins
- Paul Turley (@paul_turley) walks through Demystifying the Power BI XMLA Endpoint
- Kasper de Jonge (@kjonge) describes How to point existing reports to a new dataset in Power BI (even from AAS)
- On the SQL Shack blog, Aveek Das (@avikoleum) describes How to access Power BI REST APIs programmatically and writes about Programmatic access to Power BI PowerShell commandlets
- James Serra (@JamesSerra) blogs about Monitoring Power BI
- Brett Powell (@BrettPowell76) writes about Simple DirectQuery Performance Tips
- On the Blue Granite blog, Dan Szepesi (@szBigDan) describes How to Improve Power BI Performance - Part I
- On the Power BI Community site, Nandu Krishna (@NanduKrishnaVS) describes Dynamic Page Navigation Based on User Login
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Implementar seguridad a nivel de filas (RLS) de un principio [Spanish]
- On the DataAP blog, Hariharan Rajendran (@imhariharanr) explains how to Migrate RDL reports to Power BI – RDL Migration Tool
🌐 General
- On the Power BI blog, Arun Ulag (@arunulag) writes about the Azure Synapse Analytics public preview
- Also on the Power BI blog, Sujata Narayana shares the Power BI Desktop May 2020 Feature Summary
- Joseph Yeates (@FthrsAnalytics) blogs about What's New in Power BI – April 2020
- On the Power BI community blog, Miguel Escobar (@EscobarMiguel90) writes about the Power BI Spanish Forum
- Adam Saxton and Patrick Leblanc (@GuyInACube) share a REPLAY Power BI tips from the Pros – LIVE Hangout May 23, 2020
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 146 - May 2020 Power BI Desktop Update
- Adam Saxton (@GuyInACube) talks about Lots of Power BI community posts... (Roundup | May 18, 2020)
- On the Power BI Community site, Greg Deckler (@GregDeckler) writes Before You Post, Read This
- Also on the Power BI blog, Kelly Kaye writes about the Microsoft Business Applications Summit 2020 – Power Platform sessions quick reference
- The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 120
- Rafael Mendonça (@rafaelmpsantos) writes 5 Features que VOCÊ VAI AMAR ter no Power BI [Portuguese]