Datamart SQL query - Evaluation was canceled.

[yk98]

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?

[Anonymous]

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.

[Anonymous]

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]

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.