When a Project Online report is created using Excel 2013, you can open it in Excel Web App and refresh the OData feeds in the report. This retrieves the most recent data in Project Online.

Excel Web App uses the BI Azure Service to refresh the Project Online OData connections. For this to work, you must first grant the BI Azure Service permission to access Project Web App.

 Note    You only need to grant this permission one time for each Project Web App site.

1. Log on to Project Online.
2. Add the following to the end of your Project Web App URL: /_layouts/15/appinv.aspx

For example, if your Project Web App URL is http://contoso.sharepoint.com/sites/pwa, type in this URL: http://contoso.sharepoint.com/sites/pwa/_layouts/15/appinv.aspx

3. In the App ID field, type 00000009-0000-0000-c000-000000000000, and then click Lookup.

 Tip    Try copying and pasting that code. If that doesn’t work, that first set before the 9 is seven 0s, and that last set is twelve 0s.

4. In the Permission Request XML field, copy and paste the following code:

<AppPermissionRequests>
<AppPermissionRequest
Scope = “http://sharepoint/projectserver/reporting&#8221; Right=”Read”>
</AppPermissionRequest>
<AppPermissionRequest
Scope = “http://sharepoint/content/tenant&#8221; Right=”FullControl”>
</AppPermissionRequest>
</AppPermissionRequests>

5. Click Create.
6. On the next page, click Trust It to trust the BI Azure Service on your Project Web App site.

You should now be able to refresh your Project Online reports in Excel.