Scheduled Refresh Error

[Anonymous]

Hi I am getting the below error while doing scheduled refresh.

Tried the below methods but none proved to be effective - 

1. Updated the gateway
2. Restarted the on-premise gateway server

Need support as this is causing a lot of issue very frequently.

Data source error:	{"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: <table-name>
Cluster URI:	WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID:	25aff5b0-fe9b-460c-88a1-50f7d92d16db
Request ID:	099c2f4f-d607-4acc-8d94-5df1751c173d
Time:	2022-05-09 09:32:21Z

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

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.

[Anonymous]

Hi @Anonymous 

It's a timeout error and it seems like multiple datasets are being refreshed at the same time.

Please schedule it for some other time and check.

[Anonymous]

Made sure that there is gap of 1 hour between the different dataset refreshes. Then also it is happening.