Forum Discussion
Unexpected error; Evaluation was canceled
Hello,
For 3 months I have been plagued by the error "Unexpected error: Evaluation was canceled". This costs me between 2-4 hours in an 8 hour workday going through each query selecting the query and selecting refresh preview.
-This happens in multiple data sources including Analysis Services, SQL, and Excel
-I have cleared the permissions with no luck
-I have 20+ queries in the Query Editor and none of them can be removed;they are all essential to the model
-My PBI models range from 8KB-169,000KB in size
-I am not able to provide a sample file to replicate the data but rest assured I have the issue at least 10+ PBI desktop files
-I am working on the PBI Desktop; I am not really interested in building on the web because I feel like this is a separate issue
-I have updated the settings to not download background data and I have also disableed the parallel loading of tables
-I have cleared the cache
-I have disabled the load of queries that are needed in the query editor but are not needed in the model
Is there anyone out there that can save me from the wasted time of clicking through each query just to get a query to refresh (keeping in mind the query refreshed completely in less than 5 minutes as of December 2019).
Appreciate any specific steps that I have not detailed above 🙂
19 Replies
anthonylohHelper I
Did you ever find a solution? I'm experiencing the same issue and going through and refreshing the 18 queries in my report is frustrating and time consuming. Expecially now today one of my queries hangs and won't refresh at all.
anthonylohI have not found a solution. It seems to be more frequent in my large queries but that is all I have identified. Best of luck and if you find something please share!
Hi Anonymous ,
I had facing the same issue and I solved this issue in this way:
- Go to Transform data;
- Go to Data Source settings -> Data source in current file -> Edit premissions;
- Edit Credentials and sign in as different user (the same user it was before...) and save and close;
- Try to refresh preview and check if the error still appear.
For me this helped.
Lars
- Greg_Deckler
Community Champion
Seems like there have been lots of issues of late with data refresh in the Service. My guess is Temporary Service Insanity Syndrome (TSIS), which happens from time to time. You may have been caught up in that.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". Hi Anonymous,
Sorry I can't reproduce your problem. According to the information I searched, this problem may be caused by disabling the option "Allow data preview to download data in the background". Could you please check this option setting in your side? (In Power BI Desktop, select File > Options and settings > Options, and then select the Data Load page)
In addition, hope the following documentations will help you.
https://docs.microsoft.com/en-us/power-bi/guidance/power-query-background-refresh
https://community.powerbi.com/t5/Desktop/Unexpected-error-Evaluation-was-canceled/td-p/456055
Best Regards
Rena
Hi Anonymous ,
Sorry I haven't found a suitable solution so far. There is one workaround : select the failed queries about Query Editor and hit the Retry button after researched. Maybe you can create a support ticket ask for help.
Best Regards
Rena
I have the same issue. it has started when I refreshed data table and it got suspended for an hour with message "evaluating". I canceled the refresh and tried again, then it worked. but later when I had to update one of the information tables and went to the editor, all queries have this error "evaluation was cacelled" and exclamationmark and I even cannot edit them (the preview is not loaded dueto error). When I press retry button, query gets suspended for hours and I have to cacel it.
I am not sure how to solve it. queries can be refreshed without opening, but one source had been changed for one of the information tables (added columns) and I need to change a query so it could be refreshed, and it does not work
Hello Jennie,
Hope you doing well!.
1) Option & Setting - Option - Data Load - Clear cache
2) I have mysql query and it was long and critical query so I updated query and make little bit efficient so now is working very well.
Sometime database side is not enough space (hit too many cost) then we will get issue. After updating my query working well.
Best Regards,
Harshal
_Kevin_Hello Anonymous
I share your pain. For the past couple of weeks this probelm has intensified for me. It is months since you reported the issue. Is there still no resolution?
thanks
Kevin
- _Kevin_
Yes, my nightmare is over. Weeks later, after rebuilding the Pbix more effeicently with the same result.
The Fix: I doubled my RAM to 16GB. Sorted.While my Pbix file was only about 80mb and 1GB is the max for our licence; it does have about 20 Exel source files, and over 70 queries including helper queries to aggregate SharePoint folder files. I also use a couple of Dataflows. Use of Excel files appears to kill the RAM. If we could link via SQL or other database I don't think we would have had this probelm.
Try it - give access to a colleague with the same credentials and more RAM, see if they can refresh without issue.
Regards Kevin
