Appending queries

Within a single table, you often need to have data coming from different files/tables. You need to append data and have a unique view that will allow you to run more complex analyses. In this recipe, you will see how you can append data in Power Query with just a few clicks.

Getting ready

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

• FactInternetSales CSV file
• FactResellerSales 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 two CSV files (FactInternetSales and FactResellerSales) and load them into the Power Query view:
   

   Figure 5.20 – Queries pane

3. Select the FactInternetSales query, browse to the Add Column tab, and click on Custom Column:
   

   Figure 5.21 – Custom...