Showing results for 
Search instead for 
Did you mean: 

Sharepoint Gateway Connection Failure

After publishing a file from Power BI desktop to the, I am not able to reload my application successfully.  I currently have a connection to a sharepoint folder as well as a web source in my power bi desktop application.  When i add the sources to the "manage gateway" on, the web sources can connect but Sharepoint provides an error:


Unable to connect: We encountered an error while trying to connect to . Details: ""Hide details
Activity ID: 034ee261-0eca-42d1-9e71-ddfd5729a8fe
Request ID: 30fd70bc-eed0-202e-04d9-a95f464f3360
Cluster URI:
Status code: 400
Error Code: DMTS_UpdateClusterDatasourceCredentialsErrorCode
Time: Tue Aug 13 2019 15:02:14 GMT-0500 (Central Daylight Time)
Version: 13.0.10388.151
The Mothership: Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The credentials provided for the SharePoint source are invalid. (Source at
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: SharePoint
Microsoft.Data.Mashup.CredentialError.Reason: AccessForbidden
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SharePoint","path":""}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessForbidden

Have tried a few of the troubleshooting options such as the OAuth and Orgnizational settings, as well as the check box for web/cloud settings on the Manage Gateway settings.  





Status: New
Community Support Team

@michael_burt ,


I think you have mix sharepoint online and sharepoint on-premises, you're connecting to sharepoint online folder, not on-premises, right? In this senario, you don't need to configure data gateway, to refresh the dataset, just go to datasets-> data source credentials and input the sharepoint credentials.



Jimmy Tao

Occasional Visitor

Thanks @v-yuta-msft , I have been able to get the connection to work successfully when it is the single source within the PBIX file.  However, the error that i posted occurs during the Refresh/connection attempt when I try to set it up with an app that contains multiple sources other than sharepoint.  In my case, web sources.  





Community Support Team

@michael_burt ,


Have you configured the web source credential correctly in the dataset settings?



Jimmy Tao