none
Project Online Reports - pwa reports RRS feed

  • Question

  • How do you get the data to populate in the (3) examples of pwa reports?

    I did not see a place to select the project names or data...

    Tuesday, October 17, 2017 4:40 PM

All replies

  • Hi, you need to refresh the data connections manually in order to get some results. You can that within excel online or within the client. I would recommend to do in in the client at first.


    Best regards,

    Julian, PMP, MCP, MCSA, MCSE

    Blog: https://project-brain.com

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.


    Tuesday, October 17, 2017 8:58 PM
  • This is the message I get.

    We were unable to refresh one or more data connections in this workbook.
    The following connections failed to refresh:

    OData Projects Data 

    Tuesday, October 17, 2017 9:15 PM
  • Hi, per default solely the following roles do have access to the odata feed: Administrators, Portfolio Managers, Portfolio Viewers. Do you have one of those security groups assigned? Did you refresh in the client? Also check if this feature is enabled: https://support.office.com/en-gb/article/Grant-reporting-access-in-Project-Online-4f125cf5-a752-4ce6-b9e9-5a2eb6ace9e2


    Best regards,

    Julian, PMP, MCP, MCSA, MCSE

    Blog: https://project-brain.com

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.



    Wednesday, October 18, 2017 5:43 AM
  • Hello,

    I am a part of the administrators' group and the Portfolio Managers groups. 

    For the link that you sent, I do not see "Project Web App Permission for Excel Web App Refresh" specifically. 

    This is what I see.

    Wednesday, October 18, 2017 3:18 PM
  • If you paste the OData feed to your browser (https://<yourtenant>.sharepoint.com/sites/<yourpwa>/_api/ProjectData - Do you see the tables (your browser must be able to display xml)?


    Best regards,

    Julian, PMP, MCP, MCSA, MCSE

    Blog: https://project-brain.com

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.


    Thursday, October 19, 2017 5:43 AM