Forum Discussion
Reporting on Project Online (PWA) Timesheets
- Jul 10, 2018
Hi Andy,
The easiest way is to import only the tables that you need and create a PowerPivot model in Excel.
Best practices for querying the OData feeds an be found here:
https://docs.microsoft.com/en-us/previous-versions/office/project-odata/dn776317(v%3doffice.15)
Relevant tables could be:
- Resources - resource metadata
- Projects - project metadata
- Assignments - link between project and assignment
- TimesheetLineActualDataSet - Actual Data from timesheets
- Timesheets - Link to resource and timesheet status
- TimesheetLines - Link to resource and project and timesheet line status
The complete reference can be found here: https://docs.microsoft.com/en-us/previous-versions/office/project-odata/jj163529(v%3doffice.15)
Hi Andy,
The easiest way is to import only the tables that you need and create a PowerPivot model in Excel.
Best practices for querying the OData feeds an be found here:
https://docs.microsoft.com/en-us/previous-versions/office/project-odata/dn776317(v%3doffice.15)
Relevant tables could be:
- Resources - resource metadata
- Projects - project metadata
- Assignments - link between project and assignment
- TimesheetLineActualDataSet - Actual Data from timesheets
- Timesheets - Link to resource and timesheet status
- TimesheetLines - Link to resource and project and timesheet line status
The complete reference can be found here: https://docs.microsoft.com/en-us/previous-versions/office/project-odata/jj163529(v%3doffice.15)
Trutz_Stephani
I am looking to create reports from the timesheets submitted by team members. In the approvals, after a timesheet is approved, when I go back in history to pull up those timesheets, I only see a few columns and I dont get to see the admin hours submitted or the PTO hours submitted to the timesheet. Sometimes I also cant see some team members timesheet unless I delegate as them. If its only one timesheet, it would have been ok that I delegate as that team member and download the excel file but there are multiple team members and at times I would need to create reports for multiple previous weeks. Any guidance on this would be appreciated. Thank you