All Power BI Announcements of Microsoft Business Applications Summit 2021 in One Place

All the Power BI announcements of Microsoft Business Applications Summit 2021

The Microsoft Business Applications Summit 2021 happened recently, just a couple of weeks after the Power BI Summit, and there were a bunch of exciting announcements and updates from the Power BI team. If you missed seeing them all in one place, this article and video are a nutshell of all of those in one place.

Microsoft Fast Track Recognized Solution Architect – Power Platform

First of all, I am honored to receive the Microsoft Fast Track Recognized Solution Architect award from Microsoft mentioned by James Philips in the keynote of Business Applications Summit 2021. Thank you all my blog readers who helped me being active and doing more.

Microsoft FastTrack Recognized Solution Architect – Power BI

Now let’s jump into the interesting stuff;

Automated Insights

Power BI is Combining AI functionalities into a single, and easy-to-use feature for end-users, named as Automated Insights.

Automated Insights in Power BI

Automated Insights feature will be available later this year.

Automated Insights comes to Power BI later this year

Power BI Integration with Power Automate

Power Automate inside Power BI

This feature is more than just a refresh of Power BI dataset. This is far more powerful. You can have a button in Power BI that triggers a flow in Power Automate, and then you can access Power BI data from there and do actions based on those. This is a massive feature that can be helpful in heaps of automation on data-related scenarios from Power BI.

Power Automate and Power BI Integration is not just a refresh, it is much more

This fantastic feature is available right now, and you can use it.

Goals in Power BI

Goals in Power BI is a massive big feature that requires an article itself. Goals are new objects in the Power BI service that helps with data-driven analysis based on KPIs and scorecard.

Goals in Power BI

Goals can be defined such as KPI but with date criteria too.

Goal creation in Power BI

This can contain some powerful configurations for scorecards;

You can set the status rules

Set goal status in Power BI

Goals then can be used for automation purposes, which is another ace in this feature. This is done using Power BI goals and Power Automate’s flow.

Goal-oriented automation in Power BI

Goals can be consumed in many ways too;

Consuming goals in Power BI

or even through mobile experience of Power BI;

Power BI goals in Power BI mobile experience

Goals are available now if you want to use it.

Goals in Power BI announcing

Power BI and Hololens

You can use Power BI repots in the space using Hololens.

Power BI and Hololens

This enables you to pin Power BI objects to places and access them as you go. But this is not just for the expensive Hololens.

Power BI reports in space using Mobile

A similar experience is also available through the phone;

Power BI reports in space using Mobile
Power BI report pinned

Power BI Spatial Anchoring is the name of this feature, and it will be available later this year.

Power BI Spatial Anchoring available later this year

Sparkline in Power BI

Sparkline has been one of the most wanted features for Power BI for a long time, and here it is now;

Sparkline in Power BI

Easy-to-use Bookmarks

Bookmarks are a powerful visualization feature in Power BI, however, to get them working, you need to do a lot of extra work; such as creating the bookmark, setting the action for it, setting the target of the action, and doing it for every item (or maybe page, etc). This is now getting much easier, and you can have Navigator bookmarks, usable just with a few clicks.

Navigator bookmarks in Power BI

This lets you have customized bookmarks everywhere with a few clicks.

Customizable easy-to-use bookmarks in Power BI

Paginated report visual for Power BI reports

Paginated reports can be part of Power BI reports. this is coming to Power BI soon.

Paginated report visual for Power BI reports

Power BI integration with Teams

Power BI integration with Teams is getting better and better. You can have Power BI reports part of the Teams meeting;

Power BI reports part of a Teams meeting

Or you can have Power BI reports shared through a Teams chat;

Power BI reports shared through Teams chat

The access to the dataset hub is possible from Teams. Dataset hub is a place that you can control and monitor dataset related activities.

Dataset hub in Power BI

Power BI apps can be deployed as Teams app and be used there;

Power BI apps deployed as Teams app

The Power BI apps deploy as Teams app is coming later this year in Power BI.

Power BI apps as Teams app coming later this year

Power BI and Excel Integration

You can have an Excel file that gets data from a Power BI dataset, and uses the shared dataset.

Excel can get data from Power BI dataset

Pivot tables can be refreshed through Excel online;

Refresh Pivot tables using Excel Online

Power BI and SharePoint

You can already use SharePoint as a source to create a Power BI report, But this is now even easier. You can quickly create a Power BI report from a SharePoint list.

Quick Create Power BI report from SharePoint lists

Data Sensitivity in Power BI

Data Sensitivity labels now passes from Azure Synapse into Power BI

Data Sensitivity labels passes down from Azure Synapse into Power BI

Data Loss Prevention policy can be defined;

Data loss prevention policy in Power BI

Automatic Aggregation in Power BI

This is another big step in Power BI towards better performance of the reports. You can at the moment use aggregations to speed up the performance of your report, but this process requires some steps; such as creating the aggregated tables, setting up the configuration, and some other steps. Using Automatic aggregations, everything would be possible with just a few settings.

Automatic aggregations configuration in Power BI

This in simple words, will make Power BI reports faster without needing a performance tuning expert’s touch.

Power BI report with billions of rows

You can also use a what-if analysis to gauge the performance based on the settings.

Query performance impact analysis for automatic aggregations

And last but not least, Hybrid tables coming to Power BI, allows you to have blazing fast performance and also real-time data.

Hybrid table in Power BI for real-time, and blazing fast performance at the same time

Automatic aggregations comes to Power BI later this year.

Automatic aggregations comes to Power BI later this year.

Streaming dataflows

Streaming data is not ugly anymore, you can transform it while it streams. This is possible using streaming dataflows.

Power BI streaming dataflows

Streaming dataflows allows Power Query transformations on top of the streaming data. This feature will be available later this year.

Streaming dataflows in Power BI later this year.

Power Query Recent updates

There has been massive super powerful updates in Power Query especially in Power Query online and the dataflow experience, this is not just the graphical experience as showed below;

Rich graphical user interface for Power Query online

The mighty new diagram view, which is not just for queries, but also for steps;

The new diagram view in Power Query online

This is also very easy for adding new steps and transformations through the interface.

Applying transformations from the diagram view

I have to say it this way that; exactly opposite of DAX that is still one of the challenges of many Power BI users, the Power Query becomes easier and easier every day. Everyone can use it.

This is not just for the graphical part, but also for important back-end stuff such as Query plan.

Query Plan in Power Query

There are many other fantastic features already published in Power Query in Power BI Desktop that are coming to Power Query online soon. such as Text/CSV by example.

Text/CSV by example in Power Query

Power Query team has a great roadmap of upcoming features, which worth checking out and tuning in for it.

Power Query roadmap

Video

Summary

In a nutshell, Power BI is up to many amazing upcoming features. I highly recommend watching the below sessions to learn more about the features mentioned:

Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

3 thoughts on “All Power BI Announcements of Microsoft Business Applications Summit 2021 in One Place

  • This is a great list. Thank you for saving me the time of having to put it together. 🙂

  • Hi Reza,

    Amazing post and always a pleasure to read. Was wondering if you know anything about the Hybrid Tables. Not sure if they were ever on Microsoft’s planned waves, but I can’t find them now. Has the feature been backlogged?

    I need direct query for the last day records for a very large dataset, would you say a composite model with this same fact table in DQ and Import mode (filtered appropriately to avoid matching dates) would be the best option with what is available so far?

    Thanks!

    Paul

    • Hybrid tables should be a good use for your scenario.
      In the meantime, there are a number of options you can use. one option is to create an aggregation with monthly/quarterly snapshots for older dates, and daily for new dates. This should give you a near direct query scenario.
      Cheers
      Reza

Leave a Reply

%d bloggers like this: