Connect to Project Online data through Power BI Desktop
You can connect to data in Project Online through Power BI Desktop.
Step 1: Download Power BI Desktop
Download Power BI Desktop, then run the installer to get Power BI Desktop on your computer.
Step 2: Connect to Project Online with OData
Open Power BI Desktop.
On the Welcome screen, select Get data.
Select OData Feed and choose Connect.
Enter the address for your OData feed in the URL box, and then select OK.
If the address for your Project Web App site resembles https://<tenantname>.sharepoint.com/sites/pwa, then the address to enter for your OData Feed is https://<tenantname>.sharepoint.com/sites/pwa/_api/Projectdata.
Power BI Desktop prompts you to authenticate with your work or school account. Select Organizational account and then enter your credentials.
The account you use to connect to the OData feed must have at least Portfolio Viewer access to the Project Web App site.
From here, you can choose which tables you would like to connect to and build a query.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for