Showing results for 
Search instead for 
Did you mean: 

Random Refresh Error DM_GWPipeline_Gateway_MashupDataAccessError to a Sharepoint library

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


Status: New
Community Support

@Cheyenne_Jacobi ,


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

Support Ticket.gif 


Jimmy Tao

New Member

Thank you, entered the support ticket

Regular Visitor

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

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


Helper V

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? @Cheyenne_Jacobi  @v-yuta-msft @csabia