In real-time your data will be in normalized format but in some situations might need the de-normalized data. In this situation you can combine those tables using query editor. In this article, we will show you, how to combine multiple tables in Power BI with example.
How to Combine Multiple Tables in Power BI
From the below screenshot 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 demonstration purpose, we are going to use combine these three table. To do so, please click Edit Queries option under the Home tab.
Clicking Edit Queries option will open a new window called Power Query Editor.
From the below screenshot you can see that the Product Subcategory table has the connection with both the Product and Product Category table.
Before we start combining, let me duplicate this table by right-clicking the table and selecting the Duplicate option from the context menu.
We renamed it as Product Information
Click on the table on any row will show you the respective table information
To combine the Dim Product table, Please click on the right corner of the Dim Product column header. This will open 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 product table
Now you can see those column 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 just 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 create a table with this newly created table. As you can see from the below screenshot, we also formatted the Table as well.