Sharepoint Gateway Connection Failure

[Anonymous]

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

[v-yuta-msft]

@Anonymous ,

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

Regards,

Jimmy Tao

[Anonymous]

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!

[v-yuta-msft · Accepted solution]

@Anonymous ,

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.

 

Regards,

Jimmy Tao