Hi ,
Im use in power query to collect data from folder
But i want that the refresh will be done every time that the folder add another file
With code can i use for that ?
I don't believe you can trigger a query refresh based on changes in the folder it connects to. Though you can control the refresh rate in Query Properties. For instance by setting it to every 5 minutes or to refresh upon opening the file, or both.
I saw the video
but he explain how to do that when the data source is in the same workbook ( different sheet )
i try to refresh from a folder that update with another file .
Riny gave you the answer, but if you want to do that froma file elsewehere on the netwrok you will have to program a macro thet is triggered at a interval you can set to check if the file has been changed.
Based on that you can then add code to do the refresh or more.
Just some ideas that have come up
