Modeling view in Power BI Desktop (preview)

With the Modeling view in Power BI Desktop, you can view and work with complex datasets that contain many tables. With Modeling view, you can do the following:

Enabling the Modeling view preview feature

The modeling view feature is in preview and must be enabled in Power BI Desktop. To enable Modeling view, select File > Options and Settings > Options > Preview Features, then select the Modeling view checkbox as shown in the following image.

Enable the Modeling view preview feature in Power BI Desktop

You'll be prompted that you need to restart Power BI Desktop for the preview feature to be enabled.

Restart Power BI Desktop to enable preview features

Using Modeling view

To access Modeling view, select the Modeling view icon found on the left side of Power BI Desktop, as shown in the following image.

The Modeling view icon  in Power BI Desktop

Creating separate diagrams

With Modeling view, you can create diagrams of your model that contain only a subset of the tables in your model. This can help provide a clearer view into the tables you want to work with, and make working with complex datasets easier. To create a new diagram with only a subset of the tables, click the + sign next to the All tables tab along the bottom of the Power BI Desktop window.

Create a new diagram by clicking the + sign in the tabs section

You can then drag a table from the Fields list onto the diagram surface. Right click the table, and then select Add related tables from the menu that appears.

Right-click a table and select Add related tables

When you do, tables that are related to the original table are displayed in the new diagram. The following image shows how related tables are displayed after selecting the Add related tables menu option.

Showing related tables

Setting common properties

You can select multiple objects at once in Modeling view by holding down the CTRL key and clicking multiple tables. When you select multiple tables they become highlighted in Modeling view. When multiple tables are highlighted, changes applied in the Properties pane apply to all selected tables.

For example, you could change the storage mode for multiple tables in your diagram view by holding down the CTRL key, selecting tables, then changing the storage mode setting in the Properties pane.

Select multiple tables by holding CTRL, then set common properties across all selected tables

Next steps

The following articles describe more about data models, and also describe DirectQuery in detail.

DirectQuery articles: