Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Scheduled Refresh Error

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
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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