cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Willborn
Advocate II
Advocate II

Unexpected error: Evaluation was canceled. > After May Release Update

Hi there

 

Just got the error message "Unexpected error: Evaluation was canceled." in PBI Desktop after updating the release.

I cannot load my data sources (several types) anymore - but only those I've added in the April release (or earlier). I actually can add data sets on the new release, and they work. So the problem is only with the ones created in the earlier version.

 

Could not find any information about this problem on the net so far.

 

What I did:

Updated from April Release to Release Version: 2.35.4399.601 64-bit (Mai 2016)

Uninstalled PBI and reinstalled it again.

Cleared the Cache.

 

Anything else I can do? Need to update the Reports... ;o(

 

Thank you!

29 REPLIES 29
Anonymous
Not applicable

Greetings the same error has appeared for me and it's 2021,is there any solution to this long-lasting error.

CaronTurner
Frequent Visitor

This is such a time wasting and annoying error.  @Admin - is there any resolve for this longstanding issue.  I have spent hours of my life that I will never get back just pressing the retry button on my queries. 

 

updated to August 2020 release, with no difference in behaviour. 

AliceW
Impactful Individual
Impactful Individual

They seem to have fixed it with the latest (September?) version. Fingers crossed it stays this way!

Hello all,

 

For me it got solved with July's update. The only thing I did before refreshing was something previously suggested in another post:

 

Go to Data Source Settings and clear all permissions. Then refresh.

 

That worked for me, hopefully will also work for you.

 

Regards,

BDonnellon71
Regular Visitor

I'm having the same problem.  Has anyone found a permanent resolution?  Especially during this work from home scenario, clearing the cache and refreshing every single time is painfully slow and it is greatly impacting dashboard availability and reliability.  

I am having this exact same issue.   It's August 12 now.  

 

Any resolution??

isakalley
Frequent Visitor

Facing the same issue post May release.

Haidann
Helper I
Helper I

anyone know how can we solve this problem??

alan7lp
Helper III
Helper III

It seems I am then not the only one having the exact same issue. Started to happen after May Update. This is very annoying. I can't update my main report which is also being used by many people across the company.

 

Does anybody knows is this has been picked up already of if somebody was able to create a support ticket for it? I am desperate 😞 

AliceW
Impactful Individual
Impactful Individual

It started after installing the May release here too.

It does work in the end, but you have to wait about 20 minutes per dataset and click on evaluate on a lot of query steps and wait for each to be resolved before clicking on the next one.

This is why I'm nervous about downloading new upgrades 😞

Thanks for the quick reply @AliceW ,

 

Do you mean that I need to go to the query and click in "retry" for every single query I have with an error sign, one by one and then and only then I will be able to close & apply and new data will be fetched?

 

This is insane, it will take me ages with the large amount of data I have. 

AliceW
Impactful Individual
Impactful Individual

Get some coffee, play some YouTube vids, and click on 'Retry' everytime to you see the process has finished for the previous step... I know, it's crazy, but this is what worked for me (during the weekend, I was getting desperate, as I started rushing it).

I will give it a try. I hope it will work.

 

But even if it does, this should be picked up by somebody, right? We can't run our reports this way. I have a couple of colleagues having an older version of Power BI and they have no issues whatsoever, it's clearly something they did with May update 😞

 

I am feeling hopeless! 

AliceW
Impactful Individual
Impactful Individual

@alan7lpI agree, it shouldn't happen. Usually a Microsoft forum admin jumps in threads like this the next day.

Haidann
Helper I
Helper I

I have the same issue too

Anyone know how to solve this"??

Anonymous
Not applicable

Hi, for me this happens if I add columns to data source. I solved this just by opening query editor and clicking "retry" to the tables with this error.

Sparta100
Advocate I
Advocate I

Has anyone found a fix for this. Enormous amounts of time wasted in PQ individually opening, refreshing, and then closing hundreds of queries that have an inexplicable error warning (yellow triangle with exclamation point) that simply says: "Unexpected error: Evaluation was cancelled." My queries are 95% connection only and there are no detectable problems other than an this inexplicable warning everywhere. The warning goes away after individual manual refresh but there's no way to know if and when something "real" is going wrong. Read everything I can find and utterly exhausted.

@Sparta100Were you able to figure this one out? Thank you.

Eric_Zhang
Microsoft
Microsoft



Just got the error message "Unexpected error: Evaluation was canceled." in PBI Desktop after updating the release.

I cannot load my data sources (several types) anymore - but only those I've added in the April release (or earlier). I actually can add data sets on the new release, and they work. So the problem is only with the ones created in the earlier version.

 


@Willborn

 

The problem is not quite clear for me. Is the problem that you cannot add other data source types in the pbix created in Apr release than the already created ones when opening that pbix in May release? If yes, May I know what are the already created types and how can I reproduce it. If possible, can you upload the problematic pbix?

By the way, did you send a frown when the error occured?

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors