Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
145
Views
Topic starter
Hi
Has anyone come across this before?
I update the query but the worksheet is not updated. I open the query and you can see it has refreshed but the data does not feed to the worksheet. I delete the data in the worksheet and it remains blank. The query has been in use for months with no issue.
How can I resolve this?
Many thanks
Kasey
Posted : 04/06/2024 6:23 am
Difficult to know what's going on without seeing the file.
Posted : 04/06/2024 6:42 am
Kasey, something similar happened to me a couple of times. I could not figure out the reason behind it, but as a workaround, I:
- First right-clicked on my query in the "Queries & Connections" pane --> Load To... --> Only Create Connection --> OK.
- Immediately after this, again right-clicked on the query in the "Queries & Connections" pane --> Load To... --> Table --> OK.
The query reloaded my data back in the table and I was able to keep refreshing as usually.
Posted : 05/06/2024 9:03 am
