Weekly Roundup for May 10, 2021

Here’s a recap of the major Power BI-related announcements at the Microsoft Business Applications Summit (MBAS), the biggest Power BI conference of the year.

 

This is one of the best Power BI-related tricks I’ve seen in a while. Patrick LeBlanc shows you how to very easily set up email subscriptions with RLS and roles.

 

Microsoft is introducing an entirely new component of Power BI — Goals. I’ll be curious to see how people use this. I think it could be particularly useful if users incorporate data driven goals and roll-up logic.

 

Adam Saxton shows you the current state of source control within Power BI. Good to know that Azure DevOps and GitHub integration are coming to Deployment Pipelines!

 

For any of you true geeks out there, you can now see the query plan use by Power Query Online. I’m looking forward to them bringing this to Power BI Desktop.

 

Required Reading: Marco Russo gives you the current state of the art for development tools for Tabular models (i.e., Power BI datasets) in 2021. For any serious Power BI developer, you need to read this.

 

Here is a comprehensive overview of all the announcements and new features at Microsoft Business Application Summit (MBAS).

 

Patrick LeBlanc shows you how to enable query folding for native SQL queries. This has the potential to have a significant performance boost.

 

You can now backup and restore Power BI datasets. This could be critical for various regulatory and reporting requirements that your enterprise may face.