Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • JS
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs
  • MySQL

Joins in Power BI

Power BI supports all major joins that are available in SQL. Let me show you how to use joins in Power BI to join multiple tables with an example. The following join types are the Standard join types in Power BI and SQL

  1. Inner Join: Returns the rows present in both Left and right table only if there is a match. Otherwise, it returns zero records.
  2. Full Outer Join: It returns all the rows present in both the Left and right table.
  3. Left Outer Join: It returns all the rows present in the Left table and matching rows from the right table (if any).
  4. Right Outer Join: Returns matching rows from the left table (if any), and all the rows present in the SQL Right table.

How to Perform Joins in Power BI

To demonstrate the Power BI join types, we are going to use the tables that we imported in the Load Data from Multiple Data Sources article.

To show the join operations on existing tables, please click the Edit Queries option under the Home tab.

Joins in Power BI 1

The below Power BI screenshot show you the data present in the Employees table

Joins in Power BI 2

The following screenshot shows you the data present in the Department Table.

To perform Power BI Join operations on any table, we have to use the Merge Queries button present in the Home tab

Joins in Power BI 3

This drop-down list has two options:

  • Merge Queries: It merges the second table inside this original table.
  • Merge Queries as New: It creates a new table with the result of joining the first and second tables.
Joins in Power BI 4

Let  me select the Employees table, and select Merge Queries as a New option because we don’t want to disturb the original table

Joins in Power BI 5

The following window will open. Use this window to select the Second Table, Join Type, and standard column filed in both the tables.

Joins in Power BI 6

We are selecting the Department table as the second table.

Joins in Power BI 7

Now you can see the list of supporting join types.

Left Outer Join in Power BI

For now, we are selecting the Left Outer Join

Joins in Power BI 8

Next, we selected the DeptID from Employees and Department table as the common fields

Joins in Power BI 9

Now you can see the new table called Merge1 with all the fields from the Employees table along with one extra filed of values table

Joins in Power BI 10

Click on the table on any row show you the respective table information

Joins in Power BI 11

Please click on the right corner of the Department column header. This will open the following window. Use this window to select the required fields from the department table.

Joins in Power BI 12

Let me select the Department name from the department table, and click OK

Joins in Power BI 13

Now you can see the Department name merge with the Employee table.

Joins in Power BI 14

Right Outer Join in Power BI

Let me select the Employees table as the first table, Department table as the second table. And the Dept Id is the common filed, and right outer join as the join type.

Joins in Power BI 15

Now you can see the new table result of the Power BI right outer join

Joins in Power BI 16

Full Outer Join in Power BI

Let me select the Employees table as the first table, Department table as the second table. Here, we select Dept Id is the common filed, and full outer join as the join type.

Joins in Power BI 17

Now you can see the result of Power BI Full outer join in a new table

Joins in Power BI 18

Inner Join in Power BI

Let me select the Employees and Department tables, Dept Id as the common field, an inner join as the join type

Joins in Power BI 19

Now you can see the result of Power BI Inner join in a new table

Joins in Power BI 20

Filed Under: Power BI

  • Install Power BI Desktop
  • Connect Power BI to SQL Server
  • Add Rename and Duplicate Pages
  • Connect to Multiple Excel Sheets
  • Get Excel Data to Power BI
  • Get Text File Data to Power BI
  • Load Data from Multiple Sources
  • Remove Power BI Table Columns
  • Create Power BI Bins
  • Power BI Joins
  • Change Column Data Types
  • Combine Multiple Tables
  • Power BI Clusters
  • How to Enter Data into Power BI
  • How to Format Dates in Power BI
  • Create Power BI Groups
  • Create Power BI Query Groups
  • Create Power BI Hierarchy
  • Power BI Pivot Table
  • Power BI Unpivot Table
  • Rename Power BI Table Names
  • Rename power bi column names
  • Split Columns in Power BI
  • Remove reorder power bi column
  • Power BI Area Chart
  • Format Power BI Area Chart
  • Power BI Bar Chart
  • Format Power BI Bar Chart
  • Power BI Clustered Bar Chart
  • Clustered Column Chart
  • Create a Power BI Card
  • Format Power BI Card
  • Create Power BI Multi-Row Card
  • Format Power BI Multi-Row Card
  • Power BI Column Chart
  • Format Power BI Column Chart
  • Power BI Donut Chart
  • Format Power BI Donut Chart
  • Power BI Funnel Chart
  • Format Power BI Funnel Chart
  • Power BI Heat Map
  • Power BI Line Chart
  • Format Power BI Line Chart
  • Line & Clustered Column Chart
  • Format Line & Clustered Column
  • Line & Stacked Column Chart
  • Format Line & Stacked Column
  • Power BI Matrix
  • Format Power BI Matrix
  • Power BI Table
  • Format Power BI Table
  • Add Data Bars to Power BI Table
  • Add alternate Table Row Colors
  • Power BI Pie Chart
  • Format Power BI Pie Chart
  • Power BI Ribbon Chart
  • Format Power BI Ribbon Chart
  • Power BI Treemap
  • Format Power BI TreeMap
  • Power BI Scatter Chart
  • Format Power BI Scatter Chart
  • Power BI Stacked Area Chart
  • Power BI Stacked Bar Chart
  • Format Stacked Bar Chart
  • Power BI Stacked Column Chart
  • Format Stacked Column Chart
  • Power BI Waterfall Chart
  • Format Power BI Waterfall Chart
  • Power BI 100% Stacked Bar Chart
  • 100% Stacked Column Chart
  • Create a Power BI Map
  • Format Power BI Map
  • Power BI Filled Map
  • Format Power BI Filled Map
  • Power BI Basic Filters
  • Power BI Slicer
  • Power BI Top 10 Filters
  • Power BI Drill through Filters
  • Power BI Filters on Measures
  • Power BI Advanced Filters
  • Power BI Report Level Filters
  • Power BI Page Level Filters
  • Power BI Calculated Columns
  • Add Conditional Column
  • Create Power BI Custom Column
  • Power BI Calculated Measures
  • Power BI Calculated Tables
  • Power BI DAX String Functions
  • Power BI DAX Math Functions
  • DAX Trigonometric Functions
  • Power BI DAX Date Functions
  • Power BI DAX Logical Functions
  • Power BI DAX Agg. Functions
  • Power BI Dashboard Introduction
  • Power BI Dashboard Settings
  • Power BI Dashboard Actions
  • Delete Power BI Dashboard
  • Subscribe Power BI Dashboard
  • Add Web Content to Dashboard
  • Add Image to Dashboard
  • Add video to power bi dashboard
  • Add Title to Power BI Dashboard
  • Pin Workbooks to Dashboard
  • Register to Power BI Service
  • Connect to Power BI Service
  • Create Power BI Workspace
  • Share Power BI Workspace
  • Create a Report in Workspace
  • Rename a Report in Workspace
  • Rename a Dataset in Workspace
  • Quick insights in Power BI
  • Get insights in Power BI
  • Publish power bi desktop report
  • Upload Power BI Workbooks
  • Upload Excel Files to Dashboard
  • Edit Power BI App
  • View Published Power BI App
  • Publish Power BI App
  • Share Power BI Dashboard
  • Share Power BI Workspace
  • Share Power BI Report
  • Power BI Q&A
  • Power BI Q&A Advanced
  • Customize Q&A Suggestions

Copyright © 2021· All Rights Reserved by Suresh.
About | Contact | Privacy Policy