Quick summary
Joining tables in Power BI lets you create relationships between datasets so you can build accurate, cross-table reports. Using the Model view, you can drag and drop matching fields to define how tables connect without writing any code.
Steps
- Select a data source and add tables to your Power BI report.
- Click 'Load' to load your selected tables into Power BI.
- Navigate to the 'Model' view in the left sidebar.
- 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 tables are now successfully joined in Power BI and ready for cross-table reporting.
