Semantic model refresh fails

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