Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
v-yuta-msft
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