Forum Discussion
Read Multi CSV files and generate PBI reports
I wrote an article on this
http://exceleratorbi.com.au/combine-csv-files-power-query/
The initial cnnection may be slightly different as you may be using a network folder.
I have 200 .csv files, need to generate bar/scatter report for each csv file..
is ther any option to make it easy to generate these 200 reports
Microsoft Employee
In this scenario, if these files and same structure and you want to retrieve the data into one dataset, you should try "import from folder" option as MattAllington suggested.
But if you want to create one report for each csv file( generate one dataset for each csv file and create separated .pbix file) in batch for all 200 csv files, it's not possible in Power BI Desktop. You can submit a feature reuqest on Idea: https://ideas.powerbi.com/forums/265200-power-bi
Regards,