Forum Discussion
Pulling Time Sheet Data
- May 10, 2022
Hello csmathers2 ,
You will need to use the Organization account option. From a blank Excel file, try these steps for Project Online:
- Data tab > Get Data > From other sources > From OData feed
- In the OData feed pop up, keep Basic selected and enter the PWA URL like below:
- {pwaUrl}/_api/ProjectData such as: https://tenant1.sharepoint.com/sites/PWAsite/_api/ProjectData
- Ensure Organization account is use and sign in then click Connect
- Then select the tables you want to build the reports you need
You could also look at Power BI and start with the default template: https://github.com/OfficeDev/Project-Power-BI-Templates/tree/master/Project%20Online
Many thanks
Paul
Thank youPaul_Mather. At the moment I'm having trouble connecting to the data through Excel.
I've tried the various methods of connecting, except for the Web API option. I'm not sure what is needed in the "Key" field, if that's what you're suggesting.
Any additional insights would be much appreciated.
Hello csmathers2 ,
You will need to use the Organization account option. From a blank Excel file, try these steps for Project Online:
- Data tab > Get Data > From other sources > From OData feed
- In the OData feed pop up, keep Basic selected and enter the PWA URL like below:
- {pwaUrl}/_api/ProjectData such as: https://tenant1.sharepoint.com/sites/PWAsite/_api/ProjectData
- Ensure Organization account is use and sign in then click Connect
- Then select the tables you want to build the reports you need
You could also look at Power BI and start with the default template: https://github.com/OfficeDev/Project-Power-BI-Templates/tree/master/Project%20Online
Many thanks
Paul
- csmathers2May 10, 2022Copper ContributorThanks again Paul. I was missing the _api/ProjectData piece when attempting to connect. This did the trick!
- Paul_MatherMay 10, 2022MVP
Hello csmathers2 ,
That's great to hear. Please mark the response as the best response when you can to help others.
Many thanks
Paul