Combine Multiple Tables in Power BI

Combine Multiple Tables in Power BI: In real-time, your data is in a normalized format, but in some situations, you might need the de-normalized data. In this situation, you can combine those tables using a query editor. Let me show you how to combine multiple tables in Power BI with an example.

How to Combine Multiple Tables in Power BI

From the screenshot below, you can see that there are three tables Product category, Product Subcategory, and Products table. We imported these tables in Connect to SQL article.

For the Combine Multiple Tables in Power BI demonstration purpose, we are going to combine these three tables. To do so, please click the Edit Queries option under the Power BI Home tab.

Combine Multiple Tables in Power BI 1

Clicking Edit Queries option opens a new window called Power Query Editor.

From the screenshot below, you can see that the Product Subcategory table has a connection with both the Product and Product Category table.

Combine Multiple Tables in Power BI 2

Before we start combining multiple tables in Power BI, let me duplicate this table by right-clicking the table and selecting the Duplicate option from the context menu.

Combine Multiple Tables in Power BI 3

We renamed it Product Information

Combine Multiple Tables in Power BI 4

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

Combine Multiple Tables in Power BI 5

To combine the Dim Product table, Please click on the right corner of the Dim Product column header. It opens the following window. Use this window to select the required fields from the product table.

Combine Multiple Tables in Power BI 6

We selected the Product Key, Product Name, Color, and Standard Cost from the product table

Combine Multiple Tables in Power BI 7

Now you can see those columns inside the product information table.

Combine Multiple Tables in Power BI 8

To combine the Dim Product Category table, right corner of the Dim Product Category column header. Please select the required fields from the product category table.

We just need the English product Category Name from this table

Combine Multiple Tables in Power BI 9

Now you can see the English product category name inside the Product information table.

Combine Multiple Tables in Power BI 10

Let me rename and rearrange columns, and hit Close & Apply option under the Home tab.

Combine Multiple Tables in Power BI 11

Let me create a table with this newly created table. As you can see from the screenshot below, we also formatted the Table as well.

NOTE: I suggest you refer to Create a Table, and Format a Table articles to understand the table creation and formatting options.

Combine Multiple Tables in Power BI 12