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 process. There were also times that the data had been refreshed earlier in the query, but after sometime it will repeat the refresh automatically without me doing any changes or new query to the table. This refresh processes consumed few hours. Is there any way that I can do to shorten the refresh time or avoid the same table being refreshed from time to time as my table only update once a week.