You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
The Project Admin Blog
Jan Kalis & Project Partners
Jack Dahlgren MVP
MS Project Experts
Microsoft EPM Solution, PJ
Hi! I’m Mike McLean, Program Manager with the Microsoft Project team. Today we’ll discuss some of the changes to server reporting in the next version of Project Web App (PWA), including an introduction to the new OData service.
Historically, users access data in PWA by going directly against the database or via cubes available on-premises. With the launch of Project Online this release, we also have users storing data in Office 365. To provide access to this data, we’ve built an OData service that can be used to retrieve data stored in your instance of PWA. This OData service is available for both online and on-premise deployments. Excel 2013 now has native support for OData feeds and can authenticate to Office 365 to retrieve data from Project Online. More information on OData can be found at http://www.odata.org/.
The OData service is accessed via a URL and can be found by appending /_api/ProjectData to the location of PWA.
For example, if my Project Online URL is:
My OData service can be found at:
Since the OData feed is a web service, you can navigate to it using your browser. This will help verify you have access to the OData feed. In SharePoint Permission mode, Portfolio Viewers, Portfolio Managers, and Administrators have access to the OData feed. In Project Permission mode, access to the OData feed can be explicitly granted to users.
When accessing the URL, a page will display listing all entities available in the Project OData feed. Entities are high level items such as Projects, Tasks, Risks, Issues, etc. These entities will be the items we select in Excel 2013 when building our reports.
Note: You may need to turn off “Feed reading view” through Internet Options for the entities to display!
Here is the full list of entities:
Each entity has a set of properties associated with it. For example, every Project will have an ID, Start Date, Finish Date, etc. By appending /$metadata to the end of the OData url, you can review the full list of properties available for each entity. This is the easiest way to review exactly what type of data can be consumed using the Project OData feed.
In Project 2013, there are a few sample reports included which are already connected to the OData service. In subsequent blog posts, we’ll go into specifics around OData syntax. For this post, we’ll walk through how to find these reports and refresh them to display your data.
On the PWA homepage, click “Reports”:
This will navigate you to the Business Intelligence Center for the PWA. Click “Reports”:
You’ll see a list of folders for each language available. Click the desired language:
Here you’ll see three Excel workbooks which have connections to the OData feed (for on-premises deployments you’ll also see the SQL based reports). “Project Overview” and “Resource Overview” both have connections to multiple entities, demonstrate using relationships in Excel 2013, and include charts and graphs. “Project Overview Dashboard” is very similar, but uses the new Power View technology available in Excel 2013.
Click “Project Overview” and select “Edit” to open the report in Excel 2013:
Excel may require you to authenticate. Click “Organization or School”. Then enter your onmicrosoft.com User ID and password and click “Sign In”:
Once Excel has opened the file, click any yellow bars to enable Editing and enable Content. The report will be empty because it is a template that can pull your data. On the Data tab, click “Refresh All”:
You will see Excel 2013 retrieving data:
Once the data has been retrieved, the report will populate:
The report can now be saved back to PWA by selecting File > Save As > Current Folder:
Quick reload of PWA shows the newly refreshed report saved with a new name:
Refresh the Power View workbook in exactly the same way, just make sure you click the tab “Sheet1” before clicking Data > Refresh All. The data will be retrieved into the Excel workbook model, which is then consumed by Power View:
Here are some other useful OData links.
Following the recent worldwide Project Ignite tour my colleague Jan Kalis organized as well as presentations
Сегодня мы обсудим ряд изменений, которые появились в отчетах сервера в очередной версии Project Web App (PWA), а также познакомимся с новой службой OData. До сих пор пользователи обращались к данным в PWA напрямую через базу данных или кубы, доступные
We love Project IT Pros. Always in the trenches and getting their hands dirty with the latest technologies and improvements, IT Pros are the engine that keeps many project management offices running. With the release of the new Project, now there are
Along with the general availability of Project Online in Office 365, new scenarios have been enabled for Project Online reporting. We introduced changes to the Project Online OData feed to help you better access your data using Excel 2013, and now you