Grant reporting access in Project Online
MORE ARTICLES ABOUT: 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.
Sign in to Office 365 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.
Tip If you have more than one Project Online site collection, make a note about which one has Project Web App Permission for Excel Online 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.