This is pretty cool, but can we also use this within the Excel Web App? Well, let’s try it straight. This should load all your data and show you a list of all projects with some additional information.
The report will open in Excel, and you can now select the ‘ DATA‘ tab, and press ‘ Refresh All‘.
Go to “ Reports – English – Project Overview Dashboard” and click on the 3 dots, select “ Edit“. You can open one of the existing Project Online reports with Excel. One of the tools to “explore” this Odata feed is Excel. To access this feed, all you have to do is browse to the following url: “/pwa/_api/ProjectData”. This OData service is not only available for Project online, but also for on-premise deployments. One of the features that I really like is the OData service. Project online has some great reporting features.
0 kommentar(er)
