Power Query from folder not updating deleted files

[Tarek78]

Hi All,

I have added data into my excel using power query "from a folder". I have initially 24 files. 1 per month in 2023 and 2024. I deleted 10 files in 2024 to only keep January and February data.

I refreshed everything, closed my excel re-opened it, built new pivot but I still see data for the deleted month. Do you know how to overcome this issue?

[Tarek78 · Accepted solution]

All solved. For the ones experiencing the same issue, you have to go to Power Query, go the queries you are talking about, hit "source" and point out the correct path