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

The screenshot below shows 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 will combine these three tables. To do so, please click the Edit Queries option under the Power BI Home tab.

Click Edit Queries option under Home Tab 1

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

From the screenshot below, you can see that the Product Subcategory table connects with the Product and Product Category table.

Check the Connection Between Multiple tables to connect 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.

Duplicate the Column 3

We renamed it Product Information.

Combine Multiple Tables in Power BI 4

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

Click on Row to See the Table Information 5

To combine the Dim Product table, 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.

Select required columns from second Table 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 need the English product Category Name from this table.

Choose the Column Names from Table 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 the 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