Release State: General Availability
Products: Power BI Desktop, Power BI Service (Enterprise Gateway), Dataflows in PowerBI.com (Enterprise Gateway), Dataflows in PowerApps.com (Enterprise Gateway), Excel
- Folder path
- Combine and load
- Combine and transform
Connect to a folder
To connect to a folder:
In the Get Data dialog box, select Folder.
Enter the path to the folder you want to load, or select Browse to browse to the folder you want to load, and then select OK.
When you select the folder you want to use, the file information about all of the files in that folder are displayed. In addition, file information about any files in any subfolders is also displayed.
Select Combine & Transform Data to combine the data in the files of the selected folder and load the data into the Power Query Editor for editing. Or select Combine & Load to load the data from all of the files in the folder directly into your app.
The Combine & Transform Data and Combine & Load buttons are the easiest ways to combine data found in the files of the folder you specify. You could also use the Load button (in Power BI Desktop only) or the Transform Data buttons to combine the files as well, but that requires more manual steps.
All of the files in the folder you select will be included in the data to be combined. If you have data files located in a subfolder of the folder you select, all of these files will also be included. To ensure that combining the file data works properly, make sure that all of the files in the folder and the subfolders have the same schema.
For more information about combining files, see Combine files in Power Query.