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
From the screenshot below, 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 Combine Multiple Tables in Power BI demonstration purpose, we are going to combine these three tables. To do so, please click the Edit Queries option under the Power BI Home tab.
Clicking Edit Queries option opens a new window called Power Query Editor.
From the screenshot below, you can see that the Product Subcategory table has a connection with both 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 show you the respective table information.
To combine the Dim Product table, Please 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 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 rename and rearrange columns, and hit 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.
