Forum Discussion
Nav_14
9 years agoRegular Visitor
Read Multi CSV files and generate PBI reports
Hi There, I have a multiple .csv files in FTP location, requirement is to have these .csv as input files and generate reports.. please advise the right procedure or steps. Thanks in advan...
- 9 years ago
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.
Nav_14
9 years agoRegular Visitor
Also have files in local folder.. please suggest the option/steps to generate these reports(200 .csv files)
Anonymous
9 years agoNot applicable
If you have the files in a local folder, Matt's guide should work for you, to import all 200 files into one table if they are the same structure.