none
Error Connecting to Projects OData Feed RRS feed

  • Question

  • Hi,

    I followed the instructions from http://office.microsoft.com/en-us/project-server-help/use-excel-2013-to-create-a-new-project-web-app-report-HA102923779.aspx to create a connection to the OData feed of my On-Premise Project Server 2013 instance. While selecting the Projects table and clicking Preview & Filter or Finish, I got an error "The document is not a Atom feed or entry.". The other Tables are functioning OK.

    What is the issue here? Is there a solution to it?

    • Edited by khgoh Tuesday, March 4, 2014 4:31 AM Insert screenshot
    Tuesday, March 4, 2014 4:11 AM

Answers

  • Found the issue. Looking at the ULS Logs I saw an error "The column 'ProjectID' was specified multiple times for 'OdataSelect' ". I realised that there is a custom field named " Project ID". Changing it to "Project_ID" solved the problem.
    • Marked as answer by khgoh Tuesday, March 4, 2014 5:41 AM
    Tuesday, March 4, 2014 5:40 AM