Read Multi CSV files and generate PBI reports

Nav_14,

ftp support in Power BI is a bit limited right now.

'Import from folder' as MattAllington suggests would be ideal, but will fail on an FTP source with "The folder path must be a valid absolute file path"

While a browser such as Chrome or IE will render an FTP index as HTML (e.g. ftp://ftp.bom.gov.au/anon2/home/ncc/metadata/lists_by_element/numeric), importing this from Power BI as a Web Page will fail. So you likely can't parse the index page for changing files

You CAN import a file from an ftp site via a Web Page import IF you have the full path (e.g. ftp://ftp.bom.gov.au/anon2/home/ncc/metadata/lists_by_element/numeric/numANT_11.txt)  If your 200 files were always the same names and locations, you could write a function to loop through and import them all.

Also, there may be issues refreshing files from an ftp site - see https://social.technet.microsoft.com/Forums/exchange/en-US/ceb2eb1d-83a4-4aad-b42d-5bd7e18228e8/how-to-use-excel-or-csv-file-from-ftp-location-as-data-source-in-power-bi?forum=powerquery

To improve this area, you can vote for or create an Idea: see https://ideas.powerbi.com/search?filter=merged&query=ftp

Nav_14

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,