Datamart SQL query - Evaluation was canceled.

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.