Forum Discussion
Scheduled Refresh Error
Hi I am getting the below error while doing scheduled refresh. Tried the below methods but none proved to be effective - Updated the gateway Restarted the on-premise gateway server Need suppor...
Hi Anonymous ,
That appears to be a timeout from your Gateway to your datasource.
I'd like to suggest you increase the CommandTimeout and the ConnectionTimeout parameters to two hours to see if it works. The default value for ComandTimeout is ten minutes and the default value for ConnectionTimeout is driver-dependent. You may go to Power Query to modify them.
You may try the following code in advanced editor to set CommandTimeout and ConnectionTimeout.
For further information, please refer the document .
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.