cancel
Showing results for 
Search instead for 
Did you mean: 

Refresh failure for datasets using Sharepoint lists

Hi,

 

since today we are experiencing refresh failures for all of our datasets which use sharepoint lists as one of the sources.

This issue doesn't happen when refreshing manually in desktop.

Anyone else experiencing the same?

 

{"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":"SharePoint: Request failed: Unable to connect to the remote server"}},{"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":"https://*.sharepoint.com/sites/*"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: *

Status: New
Comments
Community Support

@Vucko ,

 

Please check if there's any steps taken like merge/append tables from sharepoint online list with other on-premises data source. If so, you also need to configure data source credentials in power bi service gateway settings.

 

Regards,

Jimmy Tao