Merge Multiple Tables in Power BI: In real time, your data is in a normalized format, but in some situations, you may need the data denormalized. In this situation, you can join those tables with 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

In the screenshot below, you can see that there are three tables Product Category, Product Subcategory, and Product Table. We imported these tables in the Connect to SQL article.

For the demonstration purpose of Combining Multiple Tables in Power BI, we are going to combine these three tables. To do so, click on the Edit queries option in Power BI Home tongue.

<>

Clicking Edit queries The option opens a new window called Editor de Power Query.

In the following screenshot, you can see that the Product Subcategory table has a connection to the Product and Product Category table.

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

We change its name Product information

Click on the table in any row to display the information for the respective table.

To merge the Dim Product table, click the right corner of the Dim Product column header. Open the following window. Use this window to select the required fields from the product table.

We select the product key, product name, color and standard cost from the product table.

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

To combine the Attenuation Product Category table, right corner of the Attenuation Product Category column heading. Select the required fields from the product category table.

We only need the English product category name from this table

You can now see the name of the product category in English within the product information table.

Let me rename and rearrange the columns and press Close and apply option under the Home tongue.

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

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

Merge Multiple Tables in Power BI: In real time, your data is in a normalized format, but in some situations, you may need the data denormalized. In this situation, you can join those tables with 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

In the screenshot below, you can see that there are three tables Product Category, Product Subcategory, and Product Table. We imported these tables in the Connect to SQL article.

For the demonstration purpose of Combining Multiple Tables in Power BI, we are going to combine these three tables. To do so, click on the Edit queries option in Power BI Home tongue.

<>

Clicking Edit queries The option opens a new window called Editor de Power Query.

In the following screenshot, you can see that the Product Subcategory table has a connection to the Product and Product Category table.

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

We change its name Product information

Click on the table in any row to display the information for the respective table.

To merge the Dim Product table, click the right corner of the Dim Product column header. Open the following window. Use this window to select the required fields from the product table.

We select the product key, product name, color and standard cost from the product table.

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

To combine the Attenuation Product Category table, right corner of the Attenuation Product Category column heading. Select the required fields from the product category table.

We only need the English product category name from this table

You can now see the name of the product category in English within the product information table.

Let me rename and rearrange the columns and press Close and apply option under the Home tongue.

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

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