Load different files located in same folder into power BI

[Priya_Kulkarni]

I have multiple CSV files with different structures in one folder.
How to load them at a time?

Note: Each file is different.

[dk_dk · Accepted solution]

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.