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.