How to Join Data in Power BI

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to combine tables using relationships in Power BI.

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.

📌 Why this matters

Joining data in Power BI is a foundational skill for building accurate, cross-table reports and dashboards. By creating relationships between datasets in the Model view, analysts can eliminate data silos and surface unified insights without complex coding. This capability enables businesses to connect sales, finance, and operational data into a single semantic model, making self-service analytics faster and more reliable. Understanding how to join data directly impacts the quality of every visualization and KPI your team relies on.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI