Forum Discussion
BlissL
Jun 13, 2022Copper Contributor
Project Web App and Power BI Integration
Hi, I'm trying to connect my data from Project Web App iunto Power BI but the error message, "Failed to update data source credentials: The credentials provided for the OData source are invalid....
Paul_Mather
Jun 13, 2022MVP
- BlissLJun 13, 2022Copper Contributor
Hi Paul_Mather ,
Sorry I should've clarified - I've tried to connect data using all the options, including the organizational account and it still can't authenticate:
UPDATE:
I've managed to connect the data for the Power BI web site through using the Project Web App PBI template, but only as it had the option under the organisational account to use OAuth. However I can't find this option on the Desktop app - when I'm signed into my normal account using the Organizational Account it still can't authenticate my credentials.
- Paul_MatherJun 14, 2022MVP
Hello BlissL ,
The Organizational account is correct but it looks like you are using the incorrect PWA URL as you have /default.aspx on the end? Enter the PWA Site Url without the /default.aspx for example:
https://tenant.sharepoint.com/sites/pwa
Paul
- BlissLJun 14, 2022Copper Contributor
Unfortunately still doesn't like to authenticate with the 'right' URL without the /default.aspx at the end.
Tried all levels to apply the settings to and no authentication
- tenant.sharepoint.com/
- tenant.sharepoint.com/sites
- tenant.sharepoint.com/sites/pwa