top of page

New Features in Power BI Wave 2 2022

The latest release of Microsoft Power BI with Wave 2 2022 is packed with new features and capabilities, and if you want to learn more and know how to use them, you have come to the right place!

Jump to the specific feature you want to check out by expanding the topics below.

Power BI Premium

Automated migration experience from Azure Analysis Services to Power BI Premium.

This new capability in Power BI makes it easy for users to migrate their existing Azure Analysis Services (AAS) models to Power BI Premium. This feature is designed to simplify the migration process and reduce the time and effort required to move from AAS to Power BI. One of the key benefits of this automated migration experience is that it preserves the structure and content of the original AAS model, including data sources, tables, relationships, and measures. This means you can migrate your existing AAS model to Power BI Premium without losing your existing work or functionality. In addition, the migration process also creates a detailed report that outlines any issues or warnings that need to be addressed before the migration is complete. TO USE THIS FEATURE You must have an existing Azure Analysis Services model and a Power BI Premium workspace. Once you have these, you can initiate the migration process using the Power BI Premium web portal. The migration process involves a few simple steps, such as selecting the AAS model you want to migrate, specifying the destination workspace in Power BI Premium, and choosing the appropriate migration settings.

Power BI Premium

Query Scale-out.

Power BI Pro

Relationship editing in the properties pane.

Relationship editing in the properties pane is a new feature in Power BI Pro that provides users with a more streamlined and efficient way to manage relationships between tables in a data model. This feature allows users to create, modify, and delete relationships directly from the properties pane without navigating to a separate relationship view.


To use relationship editing in the properties pane, you must have a data model with multiple tables and existing relationships between them. Once you have this, you can access the properties pane for a table and view its relationships.

From here, you can add new relationships between tables by selecting the appropriate tables and fields and specifying the type of relationship (such as one-to-many or many-to-many). You can also modify existing relationships by changing the fields or the relationship type and deleting no longer needed relationships.

To explore all the relationship choices, simply click any relationship line in the modelling view after expanding the properties pane. By having no data preview and only validating after you apply changes, this new relationship editing experience sends a few queries. As previously, you may double-click any line in the properties pane to get the relationships dialogue for editing if necessary. It also makes it possible to edit several relationships at once. When adjusting several relationships, hold down CTRL while doing so, or use your keyboard's delete key to remove the relationships you've selected.

Replace Get data experience in the Power BI service.

Create submetrics that roll up to the metric.

Optimize ribbon in Power BI Desktop.

Improve My workspace governance.

Improvements to download Power BI for large models.

Enable large datasets.

Set default storage format.

Support single visual embedding in PowerPoint.

Mobile visual formatting.

Subscribe to reports, slicers applied.

Create quick reports on datasets with multiple tables.

Create a quick report.

Create exportable formatted data tables.

Create a table.

Which of these features are you most excited about? Let us know in the comments below.

Need help creating custom reports and analyses in Power BI? We can help. Learn how here.

bottom of page