Forum Discussion
Reporting on Project Online (PWA) Timesheets
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 youI am using the out of box Dashboards available in power BI linking to my PWA data but the Timesheet tables are not appearing in the lot. Why would that be and how can I add those tables please?
The out-of-the-box reports simply don't include the tables.
You can download the PBIX file here:
and adapt the data model to include the missing data.
- Trutz_Stephani Thanks for responding! I did look at this but can't figure out how I can bring in the additional tables I need. If I connect to power BI datasets, it only gives me the option to reconnect to the same web App data set. I am not sure what step I am missing but my aim is to be able to access all the tables available in PWA.
