Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Model view shows all of the tables, columns, and relationships in your model. This view can be especially helpful when your model has complex relationships between many tables.
Select the Model view icon near the side of the window to see a view of the existing model. Hover your cursor over a relationship line to show the columns used.
In the image, the Connections table has a Seat ID column that’s related to the Unique Seats table, which also has a seatId column. The two tables have a Many to One (*:1) relationship. An arrow in the middle of the line shows the direction of the filter context flow. Double arrows would mean the cross-filter direction is set to Both.
You can double-click a relationship to open it in the Edit relationship dialog box. For more information about relationships, see Create and manage relationships in Power BI Desktop.
Current releases of Power BI Desktop have the updated Model view enabled.
The colors in the table card headers automatically match the colors you've selected in any report theme you're using. If the color is too close to white, Model view doesn't use it in the theme headers to avoid situations where it's difficult to differentiate tables in dual mode. In the previous image the card headers are white; if the report theme was using blue, the card headers in the Model view shown in the previous image would be blue instead of white.
If your model has fewer than 75 tables, Model view shows all of your tables. If your model has more than 75 tables, instead of showing all tables you see the following image:
When your model has more than 75 tables, Power BI Desktop warns you that slowdowns might occur. Create a custom layout (select the Create a custom layout button) to reduce the significant CPU and memory used when Model view shows more than 75 tables.
There are all sorts of things you can do with Power BI Desktop. For more information on data sources, see the following resources:
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Model data in Power BI - Training
Connect Power BI to multiple data sources to create reports. Define the relationship between your data sources.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Documentation
Create and manage relationships in Power BI Desktop - Power BI
Learn how to create and manage relationships in Power BI Desktop using autodetect and manual methods.
Table view in Power BI Desktop - Power BI
Learn how the Table view helps you inspect, explore, and understand data in your Power BI Desktop model.
Use Model view in Power BI Desktop - Power BI
Learn how to use Model view to see and work with complex semantic models in a visual format in Power BI Desktop.