none
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 part.....it refreshes fine in excel 2013. 

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

    FYI

    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,

    Eric

    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 soconnorjr@gmail.com

    Tuesday, January 17, 2017 6:55 PM