Publish Works Fine, but Dataset Refresh Doesn't

[Kwikiwi]

Hi

I can publish my report to PowerBi service with no errors, but when I try refresh the dataset I get this error:

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":"Could not find a part of the path 'D:\\Data Sources\\Master Data\\Divisions.csv'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"D:\\Data Sources\\Master Data\\Divisions.csv"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Divisions.
Cluster URI: WABI-GERMANY-WEST-CENTRAL-PRIMARY-redirect.analysis.windows.net
Activity ID: b28fdca7-3a11-c530-5d1f-606d638dc4ef
Request ID: fad865e8-2f6e-f348-670b-76dc1e400f7a
Time: 2023-10-13 03:38:41Z

These are the credentials:

This is the data set gateway connections details:

All mapped to files that are located on the gateway computer which is always on HNZ-WS01 as detailed in the above image

Any idea why I'm getting an error?

Thanks

[collinq]

Hey @Kwikiwi ,

I guess it could be any of the connections but based on these screenshots, I think that the issue resides in the Saleforce connection.  The message states that one of your datasources is not set to test.  And , you are prompted to Edit Credentials for the Salesforce connection.  I would suggest that you either have the Data Source modified and confirmed that it is working without error.  And, after that, see if the yellow bar goes away that is warning about unvalidated connections.  

I think the other option is for you to try and to just click on "edit credentials" and reset it.