Merge multiple tables in Power BI

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.

combine-multiple-tables-in-power-bi-1-1253889

Clicking Edit queries The option opens a new window called Editor de Power QueryConcepto de Query¿Qué es una Query?Una query, en inglés, es una definición que significa pregunta. Trasladando este concepto al marketing digital y a internet, se traduce como el concepto que un usuario escribe en un buscador, véase Google, cuando desea realizar una búsqueda usando keywords o palabras clave. Es la serie de términos reales que se utilizan al momento de ir en busca de información en estos portales.Cuando un consumidor plus.

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

combine-multiple-tables-in-power-bi-2-4722759

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.

combine-multiple-tables-in-power-bi-3-6714500

We change its name Product information

combine-multiple-tables-in-power-bi-4-8906873

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

combine-multiple-tables-in-power-bi-5-8131144

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.

combine-multiple-tables-in-power-bi-6-1303312

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

combine-multiple-tables-in-power-bi-7-6358590

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

combine-multiple-tables-in-power-bi-8-9385530

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

combine-multiple-tables-in-power-bi-9-8963943

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

combine-multiple-tables-in-power-bi-10-5749315

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

combine-multiple-tables-in-power-bi-11-4464907

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.

combine-multiple-tables-in-power-bi-12-5557894