top of page
  • Charles Sutton

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

Get data in Power BI










Select Folder and press Connect

Open folder in Power BI














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

Select a folder in Power BI











Press Combine and select Combine and Load

Combine in Power BI











Load into Power BI











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

View fields in Power BI


 

67 views1 comment

Recent Posts

See All

1 Comment


Qurban Khattak
Qurban Khattak
Feb 18

Amazing !

Like
bottom of page