Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
@Anonymous ,
Have you configured the web source credential correctly in the dataset settings?
Regards,
Jimmy Tao
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!
@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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |