Semantic model refresh fails

[malcolm37]

My semantic model refresh works sometimes and not other times!

If I do a manual refresh to my dataset it works 8/10 times, if I set auto refresh every hour, it fails 3 times and then wont refresh again.

I have to do a manual refresh and re-enable the auto refresh. I have changed access, public, org and none. I cannot get this to run more than 1 day without failure. See error message. 

Does anyone have any answers?

I found some posts with the same error, but I have been unable to resolve this. 

Data source error: {"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":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: xxxxxxxxxxxxxxxxxxxxx.
Cluster URI: WABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 90a101f4-f6f7-400d-9876-2ac9b311d3a7
Request ID: 45d6db90-6e22-0134-abc4-d167f889974c
Time: 2024-04-23 04:33:17Z

[malcolm37]

[amitchandak]

@malcolm37 , To me seems like your on-premise gateway is not up and running always. Also the speed of that server where you have an on-premise gateway seems like an issue.

Make sure it up and running and no other process is slowing it down

[malcolm37]

Config

Amitch,

Thank you for the reply. As stated, I have everything running, I have attached images of config, utilisation and gateway version. I have restarted and logged into the gateway (is there a way to auto login to the gateway). The sync worked on a fresh restart and login to the gateway. I will see how long it lasts before it stops syncing. 
Regards

UtilitisationGateway