Forum Discussion
Poor performance in data refresh using multiple large CSV files
Power BI newbie here. I have large CSV files scattered on multiple directories. I specify datasource using Get Data > More > Folder. , Its taking too long when you hit refresh to get updated data. Do...
Hi jerald,
Having worked quite a lot with CSV's it would be ideal to put all the data into on CSV file, so it does not have to and read all the individual files.
Also currently there is no incremental refresh option as you have indicated.
You can refer to my blog post below, where I give some tips in terms of how to process CSV files as quickly as possible.