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 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.
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.
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.
We renamed it Product Information.
Click on the table on any row to show you the respective table information.
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.
We selected the Product Key, Product Name, Color, and Standard Cost from the product table.
Now you can see those columns inside the product information table.
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.
Now you can see the English product category name inside the Product information table.
Let me rename and rearrange columns and hit the Close & Apply option under the Home tab.
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.
