Create a Dataset from Multiple Files with Power BI

1. Open Power BI Desktop

2. Select Get data from the top ribbon

3. Select Folder and press Connect

4. Browse For Folder, select files, (.xls, .csv, .json, etc…), and press OK, press OK again

5. Press Combine and select Combine and Load

6. That’s it! View your Data pane and you’ll see all files were loaded into a single dataset

Open Power BI Desktop

Select Get data from the top ribbon

Select Folder and press Connect

Browse For Folder, select files (.xls, .csv, .json, etc…), and press OK, press OK again

Press Combine and select Combine and Load

View your Data pane and you’ll see all files were loaded into a single dataset.