Update faster multiple CSV from folder

[aled010]

Hi guys,

I would like to create a report of a machine who create a CSV file for each measure.  They all have the same syntaxes and are saved on the same folder

Actually, i created a query based on the folder. My problem is that this folder has lot of CSV (more than 40.000 lines from 2020 to today, the double if i want to get the data from 2018) so the refresh is really slow, it take something like 30minutes to update it

I would like to know if there's a way to refresh this query faster? Something like "If CSV file Date modified doesnt change, dont read it anymore when refresh the report". 

I already saw an alternative to not include the query when refreshing the reports, but that wouldnt work here because i need to have updated datas from my machine 

 

Thanks for your help,

[amitchandak · Accepted solution]

@aled010 , Not fully sure. But check if this can help

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...