Project Web App and Power BI Integration

Question

Hi,&nbsp;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).&nbsp;Additionally,&nbsp;I have a Project Professional 3 license with admin permissions, along with a Power BI Pro license (on 60 day free trial).&nbsp;

v-jingzhang · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
You may refer to this doc:&nbsp;https://docs.microsoft.com/power-bi/connect-data/service-connect-to-project-online. This is extracted from&nbsp;the Step 8 in it:
For Authentication Method, select&nbsp;oAuth2&nbsp;&gt;&nbsp;Sign In. When prompted, enter your Project Web App credentials and follow the authentication process.&nbsp;Note:&nbsp;You need to have Portfolio Viewer, Portfolio Manager, or Administrator permissions for the Project Web App you are connecting to.
&nbsp;
Best Regards, Community Support Team _ JingIf this post helps, please Accept it as Solution to help other members find it.

anonymous · Answer

Hi&nbsp;v-jingzhang&nbsp;&nbsp;I've so far managed to connect to the online webpage version of Power BI, but it won't let me connect the data into the desktop application. Have tried with all options on 'Select which level to apply these settings to'&nbsp;and none of them can authenticate my credentials.&nbsp;&nbsp;I have admin priviledges on the PWA site, and additionally I do have access to query the report API under&nbsp;https://tenant.sharepoint.com/sites/pwa/_api/ProjectData

amarender · Answer

Hi, May i know how to assign portfolio viewer, manager and administrator access?

Forum Discussion

Related content

Power Bi Integrations to Power Automate

Renaming a Power BI project file (.pbip)

Power BI Integration with Powerapps

Power BI - Git integration

Power BI Project file (PBIP)