Load different files located in same folder into power BI

Hi Priya_Kulkarni ,


You can connect to the folder that contains the csv files

 

and load the data without modifications

 

 

This will load all the folder contents. When you click on "Binary" in any of the rows, it will parse that corresponding csv file and load it into a table. You would need to do this for all of the files you want to load into a table. Since each file is different, I assume you want to load them as different tables. As far as I am aware there is no way to do this fully automatically in Power BI, but you can make the job less tedious by keeping the original query (the screenshot above) intact, and creating as many references of it as you have csv files that need importing.

Then clicking on different binaries in each query to parse them as csv.

 

 

If later on you add new csv files to the folder, you can just refresh the connection and add another reference that parses the new file.