Power Bi Service Refresh Failures

I have a dataset that I can refresh without issues on PBI Desktop but when refreshing on PBI Service it fails every time. I have reset all data source credentials and only receive the error on a PBI dataflow data source. The report uses three different gateways for sources other than dataflows and I have access to each source in the gateway. Any help?

This is the error I receive;

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":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"PowerBI\",\"path\":\"PowerBI\"},{\"kind\":\"SQL\",\"path\":\"JHHHHWS-DB.firstuk.com;Archive\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: vwCDMAST_Snp.
Cluster URI: WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 7570ba3f-aec0-4a64-b007-028c6fbbdfa6
Request ID: b0080ab6-3863-4833-83af-1ce964d2520b
Time: 2021-07-28 19:20:51Z