cancel
Showing results for 
Search instead for 
Did you mean: 

Sharepoint Gateway Connection Failure

After publishing a file from Power BI desktop to the app.powerbi.com, 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 app.powerbi.com, 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: https://wabi-us-north-central-redirect.analysis.windows.net
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 https://xxxxxxxx.sharepoint.com/innovations.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: SharePoint
Microsoft.Data.Mashup.CredentialError.DataSourcePath: https://xxxxxxxx.sharepoint.com/innovations
Microsoft.Data.Mashup.CredentialError.Reason: AccessForbidden
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SharePoint","path":"https://xxxxxxxxx.sharepoint.com/innovations"}]
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.  

 

Thanks

 

 

Status: New
Comments
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.

Capture.PNG 

Regards,

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.  

 

Thanks!

 

 

Community Support Team

@michael_burt ,

 

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

 

Regards,

Jimmy Tao