Couldn't refresh the connection OData Assignments Data RRS feed

  • Question

  • We have implemented the below scenario

    Installed project server 2013 and configured a project web app instance. We have created a project (sample) and also created a OLAP cube for the same instance . The cube build was successful.  We then tried to test the reports in the reports library of the project web app instance. We have opened the "Project Overview" in excel and tried to refresh the data connection. We ended up with the following the error

    Refresh Issues

    We have tried the following 

    1. Created a new project by deleting the older project

    2. Build the olap cube once again

    3. Created a new cube by deleting the older cube

    4. Tried checking in ULS logs where the analysis service is configured and project server application service is running.(we could not find the error log)

    5. Tried opening the OData files in excel. The files are opening without any issue

    please let us know what we are missing here.  We are unable to narrow down the issues

    Wednesday, December 23, 2015 5:49 AM