Grant reporting access in Project Online
Before you can use Project Online reports in Excel Online, the tenant administrator needs to activate this feature for the Project Online site collection.
Where to sign in to Office 365 for business with your admin account.
At the top of the page, select Projects. Or, select the app launcher , and then select Projects.
Select Settings> Site Settings.
Under Site Collection Administration, select Site collection features.
Scroll down in the list to Project Web App Permission for Excel Web App Refresh, and then select Activate.
If you have more than one Project Online site collection, make a note about which one has Project Web App Permission for Excel Web App Refresh activated. When you activate it on one site collection, it is activated for all site collections in your Office 365 tenant. However, if you ever want to deactivate it, you can only turn it off from the site collection where you activated it initially.
You should now be able to refresh your Project Online reports in Excel Online.
Before using the default Project Online reports ( Project Overview, Resource Overview, and Project Overview Dashboard), you may need to open each report in Excel 2013, refresh the data, and then save the report back to Project Online. This will update the report so that it is supported by Excel.
For Excel Online to be able to refresh the Excel reports, the Excel reports will need to use the legacy data import wizards. For details on enabling the legacy data import wizards in Excel, see Data import and analysis options.