Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Unexpected error: Evaluation was canceled

Hi,   I have always have this error message "Unexpected error: Evaluation was canceled." when I refreshed my queries. Sometimes I have to go applied steps to click on each steps for the refresh pro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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 😀

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Anonymous ,

       

      Unfortunately it didn't work in my case 😞

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous , 

        I had facing the same issue and I solved this issue in this way: 

        1. Go to Transform data;
        2. Go to Data Source settings -> Data source in current file -> Edit premissions;
        3. Edit Credentials and sign in as different user (the same user it was before...) and save and close;
        4. Try to refresh preview and check if the error still appear.

        For me this helped.

        Lars