Refresh Excel Services Reports

Hi Adele,

You can refer to this Microsoft Help article:

Granting reporting access in Project Online: https://support.office.com/en-us/article/Grant-reporting-access-in-Project-Online-4F125CF5-A752-4CE6-B9E9-5A2EB6ACE9E2

After you have enabled the site collection feature "Project Web App Permission for Excel Web App Refresh",  your reports should refresh just fine.

You should open each report once in Excel to initiate the data model, then save the file back to the document library.

And an additional note on OData feeds in Excel to ensure they refresh properly. When you modify your Excel OData connection ensure that your ODATA connection string follows the following convention:

Data Source=https://myprojecttenant.sharepoint.com/sites/pwa/_api/ProjectData/[en-us]/Projects;Namespaces to Include=*;Integrated Security=SSPI;Persist Security Info=false;Base Url="https:/myprojecttenant.sharepoint.com/sites/pwa/_api/ProjectData/[en-us]/Projects?$select=ProjectId,ProjectName,ProjectOwnerName,ProjectStartDate,ProjectFinishDate,ProjectActualWork,ProjectRemainingWork,ProjectPercentCompleted,ProjectPercentWorkCompleted,ProjectStatus,ProjectDescription&$filter=ProjectName ne 'Timesheet Administrative Work Items'"
 
The property "Data source" needs to contain only the endpoint to the service without any query or filter parameter.

The property "Base Url" contains your complete query including the fields selected and any filter applied.

Kind regards,

Trutz