Merging queries

Users usually need to merge data horizontally and enrich a table with additional columns that are not available within the main query when it is loaded from a data source.

In this recipe, you will see how to perform this merging and which steps to consider in order to get a successful result.

Getting ready

For this recipe, you need to download the following files:

• FactInternetSales CSV file
• DimTerritory CSV file

In this example, we will refer to the C:\Data folder.

How to do it…

Once you open your Power BI Desktop application, you are ready to perform the following steps:

1. Click on Get Data and select the Text/CSV connector.
2. Browse to your local folder where you downloaded the FactInternetSales CSV file and open it. The following window with a preview of the data will pop up; click on Transform Data:
   

   Figure 5.1 – CSV data preview

3. Repeat these steps for the DimTerritory CSV file in order to end up with two...