Forum Discussion

BlissL's avatar
BlissL
Brass Contributor
Jun 13, 2022

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....
App
Online
Project
BlissL's avatar
BlissL
Brass 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_Mather's avatar
Paul_Mather
MVP
Jun 14, 2022

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

  • BlissL's avatar
    BlissL
    Brass Contributor
    Jun 14, 2022

    Paul_Mather 

    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

Resources