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."

 

I have copied and pasted the PWA site link direct from the site so there are no typos in the site name and have tried to connect anonymously and with basic credentials (using my site login). 

Additional info that may be useful:

I have a Project Professional 3 license with admin permissions, along with a Power BI Pro license (60 day free trial). 

 

 

App
Online
Project
    • BlissL's avatar
      BlissL
      Brass Contributor
      Jun 13, 2022

      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

Resources