I've got PQ set up to import data from a folder. I've noticed that if I remove one of the workbooks in the source folder and refresh my query, PQ is still holding the data from the removed workbook.How do I get PQ to recognize that the data's gone?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Power Query is holding into deleted data
- Thread starter Monsignor
- Start date
Matt Allington
MrExcel MVP
- Joined
- Dec 18, 2014
- Messages
- 1,503
Something is wrong. It can't be refreshing properly - this is not possible if it is refreshing properly. You should look at your query to see what is happening.
Upvote
0
Matt, thanks for the reply.
Upon further investigation, it turned out to not be a PQ problem.
It was a process problem that created duplicates, creating the illusion that the old data was still there.
Upvote
0
Similar threads
- Question
- Question
- Question
