We couldn't refresh the connection 'OData Assignements Data' Error : While access the project overveiw report in brower and in Excel 2013. RRS feed

  • Question

  • Hello All,

    Facing this issue while opening the ProjectOverview report in Browers or in Excel 2013.

    Snapshot is attached for furthur reference.

    Error in Excel when clicking on Refresh All, it shows the information to retieving the data but after few moments it prompt this error.

    Second snapshot occurs while opening the report in browser.

    Kindly help.


    Friday, February 7, 2014 11:35 AM


All replies

  • Hello,

    The logged in user, what permission group is the user account in? Access to ODATA is control via a new permission - 'Access Project Server Reporting Service', if you are using the Project Permission mode, ensure the security group your user account is in has this permission or move the user to a different group that does have the access. If in the SharePoint permission mode the user will need to be one of the groups below:

    Portfolio Viewers, Portfolio Managers, and Administrators

    See the link below for details:

    Regarding the second option, have you enabled the 'Project Web App Permission for Excel Web App Refresh' feature? See details below:

    Once this feature is activated and your account has access to the ODATA endpoints, open the reports in Excel, update them then save them back to the report library, they should update in Excel Web App then.


    Paul Mather | Twitter | | CPS

    Friday, February 7, 2014 5:41 PM
  • Dear Paul,

    1st Query,

    Ans: As I'm using Project Server Permission mode and im logged with the user who is the member of admin group and in administrator group 'Access Project Server Reporting Service' is ticked on. So, the concern regarding permission is resolved.

    2nd Query,

    Ans: Im unable to find Project Web App Permission for Excel Web App Refresh' feature in site setting of PWA. 

    Snapshot is attached when trying to open report in browser.

    to resolve this followed below mentioned URL but unsuccessfull result

    Still facing same issue, issue is not resolved kindly help/suggest.

    Note: Im using Project Server 2013 not Project Online 2013. 

    • Edited by Danish.M Monday, February 10, 2014 11:48 AM
    Monday, February 10, 2014 11:41 AM
  • Hello,

    This refresh feature is only available for Project Online. As you are using Project Server 2013, I would recommend that you use either the OLAP cube or the PWA Reporting database as the data source, not ODATA.


    Paul Mather | Twitter | | CPS

    Monday, February 10, 2014 12:20 PM
  • Thanks for the reply,

    sharing with you snapshot of builtin "Project Overview" report in Project Server2013.

    In the below snapshot you can see in the bottom their is writter "OData Project Overview" which is by default so how can i change to other resource to get the report work. 


    Monday, February 10, 2014 12:44 PM
  • These are just example reports. You would need to build the reports you want.


    Paul Mather | Twitter | | CPS

    Monday, February 10, 2014 12:55 PM