Power BI Weekly
Issue #39 - 24th December 2019
Lots of pre-vacation announcements in the last week, it seems. Let's rattle through them. As ever, we've received the Power BI Desktop December 2019 Feature Summary which features the new method by which you can specify themes (much more easily). We've also been told about the new dedicated Power BI Activity Log, and that the Power BI Mobile new look is now GA and includes your activity feed.
Continuing with the Power BI team - a couple of notices. The first will affect many of the bloggers whose articles are featured in this newsletter, so if you're one of those - watch out for the fact that The Publish to web default is changing and it affects who can create public embed codes. Elsewhere, we've been told that Microsoft plans to discontinue the support for Transport Layer Security (TLS) versions 1.0 and 1.1 in the Power BI service as of June 2020.
Finally, Chris Webb has written abou the New "Diagnose Step" Power Query Feature In Power BI, and Darren Gosbell has announced the DAX Studio 2.10.1 release, so get upgrading!
The next edition will be on the 7th January - I don't expect much content over the next week, so we'll roll all the content into the bumper edition on the 7th. Merry Christmas to all that celebrate it!
🛠️ Data Prep
- Chris Webb (@cwebb_bi) writes about the New "Diagnose Step" Power Query Feature In Power BI
- Matthew Roche (@SQLAllFather) highlights the New resource: Generating CDM folders from Azure Databricks
- Chandeep Chhabra (@chandeep2786) describes how to create a Running Total in Power Query
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) describes how to Split / Segment / Partition / Section your table in Power BI / Power Query
- Imke Feldmann (@TheBIccountant) writes about Advanced transformations on multiple columns at once in Power BI and Power Query
🧩 Data Modeling
- Darren Gosbell (@darrengosbell) highlights the DAX Studio 2.10.1 release
- Phil Seamark (@PhilSeamark) writes about DAX : Approx Distinct Count
- On the SQLBI blog, Marco Russo (@marcorus) writes From SQL to DAX: Implementing NULLIF and COALESCE in DAX
- On the RADACAD blog, Reza Rad (@Rad_Reza) talks about DAX Variables: Better Readability, Consistency, and Performance in Power BI Calculations
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes a number of blogs How To Do Trend Analysis In Power BI Using DAX, Power BI Trend Analysis: Are Margins Expanding Or Contracting, Forecasting in Power BI: Compare Performance vs Forecasts Cumulatively w/DAX, Sam McKay Cfa Brand New Mastering DAX Calculations Course To Be Released Before End Of Year, Sam McKay explains how to Compare Actual Results to Budgets Using Power BI Forecasting and blogs about Developing Sensitivity Analysis Logic Using DAX in Power BI
⚙️ Report Design and Visualizations
- On the Power BI blog, Tessa Hurr (@tessahurr) tells us to Take a Tour of the New Sales & Returns Sample Report
- Mimoune Djouallah (@mim_djo) explains How to reduce data volume in Power BI Maps by using WKT
- On the MSSQLTips site, Scott Murray talks about Power BI Conditional Formatting for Matrix and Table Visuals
⚙️ Data Exploration
- On the RADACAD blog, Reza Rad (@Rad_Reza) walks through a Power BI Salary Survey and Report 2020 and writes about Analyzing PASS SQL Saturday data using Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) writes Heads up: The Publish to web default is changing and it affects who can create public embed codes
- Gil Raviv (@gilra) shares a New Year Resolution – Lets dispel the misconception that Power BI is a DataViz Tool
- Carl de Souza (@carldesouza) writes a number of blogs: Build a Power App Mobile App that Displays and Refreshes your Power BI Data with a Button Click, Refresh a Power BI Dataset with a Button Using the Power Automate Mobile App, How to Refresh Multiple Power BI Datasets using Power Automate and the Power BI API, How to Register an Azure App to Use with Power BI and How to Authenticate and Use the Power BI API inside Power Automate
🌐 General
- On the Power BI blog, Sujata Narayana covers Power BI Desktop December 2019 Feature Summary
- On the Power BI blog, David Magar writes about Deprecating TLS 1.0 and 1.1 support in Power BI
- Also on the Power BI blog, Kay Unkroth introduces the Power BI Activity Log
- Also on the Power BI blog, Maya Shenhav highlights that the Power BI Mobile new look is now GA and includes your activity feed
- Also on the Power BI blog, Miguel Martinez (@maikelson) asks us to Help improve Power BI - December 2019
- On the Power BI community blog, Amit Chandak (@amitchandak78) blogs about Power BI: Working with Non-Standard Time Periods
- Also on the Power BI community blog, Kumail walks through Setting Up Azure for Analytics in Power BI and Embedding
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 129 - Power BI news from SharePoint Fest Chicago 2019 and Episode 130 - The Final version of Power BI Desktop... this year