Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
397
Views
Topic starter
I loaded 32 connection-only queries yesterday and went to analyse them this morning. However, an exclamation mark was marked against each file in the query pane and they showed this message "Unexpected error: Evaluation was canceled". I was able to get everything working again by clicking on each query and then 'retry'.
Has anyone seen this error before and how would I prevent it happening again? Thank you.
Posted : 03/01/2019 10:08 pm
Hi Linda,
I haven't experienced this but some research revealed a fix might be to try clearing the cache: File tab > Options and settings > Query Options > GLOBAL: Data Load > Clear Cache.
Mynda
Posted : 03/01/2019 11:09 pm
Topic starter
Thank you Mynda!
Posted : 03/01/2019 11:29 pm