Power BI Weekly

Issue #58 - 12th May 2020

How many exciting announcements at MBAS were there?! Some incredible new capabilities are on the way. Probably the most impressive of which is the new composite models feature, highlighted in Christian Wade's session, which gives analysts the ability to extend or modify Enterprise semantic models to suit their needs. Arun Ulag has provided an overview of all the new/upcoming features in the blog Driving a data culture: from insight to action - make sure you have a flick through that (don't miss the more detailed blog on the new Personalize Visuals Experience for Power BI Reports). Elsewhere, we've received the new Power BI Desktop April 2020 Feature Summary, we've been told about the new Timely Premium Capacity Overload Alerts, and we now have the capability to Automate Data Gateway Installation (Public Preview).

Elsewhere this week, Chris Webb has pointed out the Power Query Formatter created by the Power Pivot Insights folks over in Germany, Marc Lelijveld has described how to Leverage Azure Cognitive Services in Power BI without Premium subscription, and Barrett Studdard has written an interesting blog about UI Design and Neumorphism in Power BI.

Find all the recordings of the MBAS sessions here.

🛠️ Data Prep

Jon Peltier (@PeltierTech) describes how to Use Power Query to Manipulate Your Data
Ben Gribaudo (@bgribaudo) describes Searching Power Query in Multiple Files
On the Prologika blog, Teo Lachev (@tlachev) covers Power BI Time Adventures
On the CSG Pro blog, Brian Grant (@BrianGrantBI) writes Calendarfornia Dreamin – M Calendar Script for Power Query
Chandeep Chhabra (@chandeep2786) describes how to Split by Variable Columns in Power Query
Chris Webb (@cwebb_bi) highlights the Power Query Formatter
On the Visual BI blog, Minh Dang describes Machine Learning in Power BI with PyCaret
Marc Lelijveld (@MarcLelijveld) describes how to Leverage Azure Cognitive Services in Power BI without Premium subscription

🧩 Data Modeling

Gilbert Quevauvilliers (@GilbertQue) explains how to Create Currency Formatting Strings using Calculation Groups in Power BI Premium (Soon to be Power BI Desktop) / Azure Analysis Services / SQL Server Analysis Services 2019
On the Power BI community blog, Sam McKay (@_EnterpriseDNA) writes about High-Quality Business Insights Around Revenues & Margins - Power BI Analysis and explains How to Incorporate Seasonality Adjustments for Budgets or Forecasts in Power BI
On the Purple Frog Systems blog, Jeet Kainth writes about a Cube deployment error: Cannot resolve all paths while de-serializing Database
Kasper de Jonge (@kjonge) walks through Setting up translations for datasets in Power BI premium

⚙️ Report Design and Visualizations

On the Power BI blog, Sujata Narayana announces the New Personalize Visuals Experience for Power BI Reports
On the BI Elite blog, Parker Stevens (@PowerBIElite) talks about Personalized Visuals in Power BI
On the Blue Granite blog, David Eldersveld (@dataveld) writes that Power BI Gets Personal: Easy Data Exploration for Any Viewer
On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes Visualisations de données créatives [French]
Marc Lelijveld (@MarcLelijveld) explains how to Empower end users to personalize existing Power BI reports with visual customization and writes about Power BI Lasso select, the next step in becoming the PowerPoint for data
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) describes Using Lasso with New Shortcuts
On the SQLBI blog, Marco Russo (@marcorus) blogs about Optimizing card visuals in slow Power BI reports
Barrett Studdard (@Data_Stud) blogs about UI Design and Neumorphism in Power BI
John White (@diverdown1964) describes Formatting the X Axis in Power BI Charts for Date and Time
Chris Hamill (@ChrisHamill17) writes about Themeable Backgrounds for Power BI
On the xViz blog, Bhupinder Singh talks about the xViz Hierarchy Filter – What's New and the xViz Packed Bubble Chart – Key Features
Also on the xViz blog, Dinesh Rvl explains how to Write Back Gantt Chart Project Data in Power BI to the Database

⚙️ Data Exploration

John White (@diverdown1964) describes Working with Time Zones in the Power BI Relative Time Slicer and Filter

🚀 Deployment, Security and Operations

On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes about Automation of Data Gateway Installation (Public Preview)
Also on the Power BI blog, David Magar announces Timely Premium Capacity Overload Alerts
Chris Webb (@cwebb_bi) writes about Calling The Power BI Export API From Power Automate, Part 3: Creating An Alerting Solution
On the Power BI community blog, Michal Dvorak (@nolockcz) describes Power BI Incremental Refresh with ETL
David Eldersveld (@dataveld) blogs about Configuring Postman for Use with the Power BI REST API
Fabrizio Accatino has provided A tool to quickly update permissions on Azure Data Lake Storage Gen2 files
On the Blue Granite blog, Josh Crittenden (@Jcrit44) provides some Tips for a Successful Power BI Report Server Implementation

🌐 General

On the Power BI blog, Arun Ulag (@arunulag) writes about Driving a data culture: from insight to action
On the Power BI blog, Sujata Narayana discusses the Power BI Desktop April 2020 Feature Summary
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 144 - MBAS 2020 Recap
Adam Saxton (@GuyInACube) describes that The Power BI release train has departed... (Roundup | May 4, 2020) and shares the LIVE MBAS Recap with BIFocal
Also on the Power BI blog, Megan Tomlin explains how to Learn how to deliver insights for all at this virtual event
On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) blogs about the Milwaukee Brew City PUG – April 2020
The Knee-Deep in Tech team (@KneeDeepinTech) present the Podcast episode 118