Grant reporting access in Project Online
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.
- Log on to Project Online.
- 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
- 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.
- In the Permission Request XML field, copy and paste the following code:
<AppPermissionRequests>
<AppPermissionRequest
Scope = “http://sharepoint/projectserver/reporting” Right=”Read”>
</AppPermissionRequest>
<AppPermissionRequest
Scope = “http://sharepoint/content/tenant” Right=”FullControl”>
</AppPermissionRequest>
</AppPermissionRequests>
- Click Create.
- 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.
I am getting the “Something went wrong” Error when I try this
Hi, When I try this I am getting the “Something went wrong” error, is additional steps needed?
Have you made sure that everything around Excel Services (trusted locations, users etc) has been setup correctly before following the steps mentioned?
Whre do you set up Excel Services in Project Online? We do have Secure Store available, but nowhere to configure Excel Services.
..got it. Seems like copying the XML from http://office.microsoft.com/en-us/office365-project-online-help/grant-reporting-access-in-project-online-HA104021109.aspx?CTT=5&origin=HA102923779 works, but copying from here does not. Maybe an extra line break?
Hi Ville,
Great you worked it out yourself as I have been travelling around in USA this week.
Let me know if you have other questions.
/Peter