The refresh operation failed because it took more than 120 minutes to complete

[Anonymous]

Hi Team,

When I am trying to refresh the dataset, I keep on getting this error.

The refresh operation failed because it took more than 120 minutes to complete

[manikumar34]

@Anonymous ,

When you do joins/appends in Power Query it has to load the entire table into virtual memory. This takes much time and slows down the refreshing time. And also check with your query dependency. 

If not try extending the time for refreshing. 

Regards, 

Manikumar

[Anonymous]

Can you please check if there is any such table which is not included in the refresh but is enabled in the load?

This probably can occur because of this.

[amitchandak]

@Anonymous , see if timeout parameter can help

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459