Project Online: connect to 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.
Choose OData feed and select Connect.
Enter the address for your OData feed in the URL box, and then click OK.
If the address for your Project Web App site resembles https://<tenantname>.sharepoint.com/sites/pwa, the address you’ll enter for your OData Feed is https://<tenantname>.sharepoint.com/sites/pwa/_api/Projectdata.
For our example, we’re using https://contoso.sharepoint.com/sites/pwa/default.aspx
Power BI Desktop will prompt you to authenticate with your Office 365 account. Select Organizational account and then enter your credentials.
Please note that 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. Want an idea of how to get started? The following blog post shows how to build a burndown chart from your Project Online data. The blog post refers to using Power Query to connect to Project Online, but this applies to Power BI Desktop as well.