Below error message we are getting when we try to refresh the data. Its working for one or two tables but not working for 35 to 40 odd tables. We have configured standard gateway on Azure Virtual Machine and memory looks fine as we have 32 Gig Memory on this machine.
Failed to save modifications to the server. Error returned: '{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<pi>Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"depuatweusaw001.sql.azuresynapse.net;depweusqlpool"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}
Technical Details:
RootActivityId: f1ec39d4-4773-48d7-a9ff-f4341ffb4e76
Date (UTC): 1/27/2022 11:28:16 AM
{"error":{"code":"DM_GWPipeline_Gateway_CanceledError","pbi.error":{"code":"DM_GWPipeline_Gateway_CanceledError","parameters":{},"details":[],"exceptionCulprit":1}}}
{"error":{"code":"DM_GWPipeline_Gateway_CanceledError","pbi.error":{"code":"DM_GWPipeline_Gateway_CanceledError","parameters":{},"details":[],"exceptionCulprit":1}}}
