Random Refresh Error DM_GWPipeline_Gateway_MashupDataAccessError to a Sharepoint library

[Anonymous]

Figure 1.1 shows the error message from the service which seems to pick a different file in the library each failure.  Also without making any changes in the service or the library the next refresh could be successful or fail (figure 1.2).  We have seen the random failures in the refresh history since June 17th.  Thank you for any assistance or guidance in helping to resolve our refresh issue

Figure 1.1 - Failure Error sent from failed Refresh

Report xxxx has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"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>SharePoint: Request failed: xxx Randomly selected File from the Sharepoint Library _api/contextinfo</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":" Enterprise SharePoint Site"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.SPRequestGuid","detail":{"type":1,"value":"f877659f-8091-a000-8e4c-96c2f09a5d1b"}}],"exceptionCulprit":1}}} Table: xxxx Table.

Figure 1.2 - Refresh history

[v-yuta-msft]

@Anonymous ,

I would suggest you create a support ticket here for further analysis.

 

Regards,

Jimmy Tao

[Anonymous]

Thank you, entered the support ticket

[csabia]

Hi @Anonymous , did you get a solution for the issue?

we have the same exact problem with one of our datasets, albeit with another source (postgresql).

Thanks.
Claudio

[THEG72]

Also having similar issue reported with random failures in the service and also now appearing on desktop refreshes using August 2020 version

Has this been solved yet? @Anonymous  @v-yuta-msft @csabia 

[Catherine07]

Me too same issue