Forum Discussion

yk98's avatar
yk98
Frequent Visitor
3 years ago

Datamart SQL query - Evaluation was canceled.

I have created a datamart using PBI Dataflow as my source (imported 3-4 tables). I'm using the SQL query window to run a few queries and observe the output, however, for 1 query I'm getting the error - "Evaluation was canceled". How can this be solved?

Dataflow
Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi yk98 ,

    Please have a try.

    1. Access the FILE ribbon from the PBI Desktop

    2. Choose Options and settings > Options

    3. Data Load > Clear Cache 

     

    Or 

     

    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.

     

    After this  close all PBIs and do a restart .  Hope this provides some relief .

     

    I have also found a similar post, please refer to it to see if it helps you.

    Unexpected error: Evaluation was canceled (microsoft.com)

    Do you have background analysis disabled?

     

    If it still does not help, please provide more details.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • yk98's avatar
      yk98
      Frequent Visitor
      3 years ago

      Hi Anonymous ,

       

      Are any of these solutions relevant to PBI Service DataMarts?? Because I can't find any options to change data source settings there. Your solution seems to be for PBI Desktop specifically. Is there anything for PBI Service> DataMarts?

       

      Regards,

      Yash.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi yk98 ,

    This may cause by the datasize is too large for dataflow to implement. Please refer to the similar case:Dataflows - Evaluation was canceled - Microsoft Power BI Community

     

    If it still does not help you, we suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

     

     

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.