Quick summary
Creating relationships in Power BI lets you connect multiple data tables so that your reports and visuals can accurately cross-reference and analyze data across sources. This step-by-step walkthrough shows you how to load tables and use the Model view to define and save table relationships in Power BI Desktop.
Steps
- Select a data source and add data to your report.
- Click 'Load' to load your tables into Power BI.
- Go to 'Model' view in the left navigation panel.
- Drag a field from one table to the matching field in another table to begin creating a relationship.
- In the 'New relationship' window, review Power BI's suggested relationship type, select one, and click 'Save'.
- Your relationship has been successfully created in Power BI.
