IConvertible error RRS feed

  • Question

  • Hello,

    I have a excel document with a simple ODATA connection to pwa project table (Project Online). Somewhere along the line something has gone wrong, specifically with refresh. Refresh in excel 2016 and excel online fails and gives me the Excel couldnt refresh the table projects from connection OData projects data....Object must implement IConvertible.

    Now for the strange refreshes fine in excel 2013. 

    Anyone have a idea what might have ocurred or more importantly what might fix this we have many reports that use that ODATA.


    Side note. When i use the same data string in our test pwa instance it connects and refreshes fine in all versions.

    Thanks in advance,


    Monday, June 13, 2016 10:54 PM

All replies

  • This randomly started happening in specific reports for a client this month. Did you ever find the fix? I saw other threads referencing the ParentProjectUID but we can't always edit the queries. 

    Stephen T. O'Connor Jr., PMP

    Tuesday, January 17, 2017 6:55 PM