Quick summary
Joining data in Power BI lets you create relationships between tables so your reports reflect accurate, connected insights. This process uses the Model view to visually link matching fields across datasets without writing any code.
Steps
- Select a data source and add data to your Power BI report.
- Click Load to load your data into Power BI.
- Navigate to the Model view using the left-side panel.
- Drag a field from one table and drop it onto the matching field in another table to create a relationship.
- In the New relationship window, review Power BI's suggested relationship type, select the appropriate option, and click Save.
- Your data is now joined — the relationship between your tables is successfully established in Power BI.
