Forum Discussion
Unexpected error; Evaluation was canceled
Hello, For 3 months I have been plagued by the error "Unexpected error: Evaluation was canceled". This costs me between 2-4 hours in an 8 hour workday going through each query selecting the quer...
_Kevin_
Helper I
Helper IYes, my nightmare is over. Weeks later, after rebuilding the Pbix more effeicently with the same result.
The Fix: I doubled my RAM to 16GB. Sorted.
While my Pbix file was only about 80mb and 1GB is the max for our licence; it does have about 20 Exel source files, and over 70 queries including helper queries to aggregate SharePoint folder files. I also use a couple of Dataflows. Use of Excel files appears to kill the RAM. If we could link via SQL or other database I don't think we would have had this probelm.
Try it - give access to a colleague with the same credentials and more RAM, see if they can refresh without issue.
Regards Kevin