Microsoft Power BI Cookbook

Consolidate files

The goal of this example is to produce an integrated table based on three text files stored in separate network paths:

1. Create a query to one of multiple text files that need to be integrated.
2. Click on Get Data and choose Text/CSV from the list of file sources.
3. Navigate to the folder and select the file to query.

Figure 119: Tab-delimited text file

• In this example, the three text files are tab delimited but the same process applies to other delimiters and file sources.

Figure 120: Source Folders

• If the files are stored ...