Joins

Lesson in the Power BI Roadmap · Stage 7: Relationships

Last updated 14 September 2026

What is Joins?

Joins in Power Query, called merges, combine two tables side by side based on matching values in one or more key columns. Users choose a join type such as inner, left outer, right outer, or full outer, which determines which rows are kept when matches are found or missing. This is the main way to bring related tables together before loading them into the data model.

Study this in the interactive course See the whole Power BI roadmap

Free resources to learn Joins

Official docsShape and combine data in Power BI Desktop
ArticlePower Query Basics: Merge Queries
VideoPower Query Secrets: How to Merge Tables Like a Pro!

Joins: common questions

Can I learn Joins in Hindi?

This lesson is written in English. Once you sign in, open it in the interactive course and ask the AI tutor to explain Joins in Hindi or Hinglish. The tutor answers from this lesson’s own text, so it stays on the syllabus, and it runs on your own Google, OpenAI or Anthropic key.

Is this Joins tutorial for beginners?

It is lesson 39 of 131 in the free Power BI roadmap, in stage 7, Relationships. If you are new to Power BI, start from stage 1 and come back here in order; if you already know the earlier stages, this lesson stands on its own.