Forum Discussion
Unexpected error: Evaluation was canceled
Has anyone been able to resolve this? I have tried to check and uncheck the backgroud preview, I have cleared the cache, I have tried in both the desktop program & PC app. It is not just cosmetic because my refreshes fail as a result of the queries that experience this issue. And when I go in to resolve them by walking through steps, I fix 2 queries and another one then fails. I am pulling data from SQL and have many queries as a result of complex calculations and builds. It seems to be a larger issue when I use the MERGE option however that is now always the case. At this point it is a complete work stoppage and I am wondering if the only option is to discontinue using Power BI?
I am fairly new to Power BI and was having a torrid time with this issue and looked around to see if could find anything to resolve my problem. I found the following articles seems to do the trick:
https://docs.microsoft.com/en-us/power-bi/guidance/power-query-background-refresh
For some reason this option was disabled (I must of clicked it off at some point). I think what was happening is that each time I clicked on a power query it would take time to refresh the view. I have some fairly hefty queries. If I got impatient and clicked another query then I would get this error.
You may have to do a full refresh to clear out the yellow warnings.
I can put up with the message indicating my view is out of date. I can do a full refresh at my convenience.
I hope it works for you.
Hello there,
Any news about this? It started to happen to me after May update last Thursday. Impossible to do any workaround to make it work. Have you managed Anonymous ?
I am getting desparate 😞
Anonymous I do not have a real solution but this issue popped up again with vengance about 2 weeks ago. The only thing that seemed to help (not resolve but at least reduce the time to refresh the query in the query editor to resolve the !) was to clear the cache. I am not sure if there is any correlation to me doing that and the error resolving in less time but worth a try maybe?
1. Access the FILE ribbon from the PBI Desktop
2. Choose Options and settings > Options
3. Data Load > Clear Cache
After this I generally close all PBIs and do a restart on my computer (probably overkill but just want to make sure). Hope this provides some relief 😀
Hello there,
I had facing the same issue.I solved this issue in that way:
1) Go to Data Source settings -> Data source in current file -> Clear all premissions;
2) Go to Global permissions -> Clear all premissions;3) Connect again to the source of your data;
4) Try to refresh all and go to transform data to check if the error still appear.
Let me know if that worked for you.
Thanks Anonymous ,
Unfortunately it didn't work in my case 😞
