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)
I 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.