Error: Errors in the high-level relational engine.Errors in the high-level relational engine...Object must implement IConvertible....when importing an OData Feed to Excel

You may encounter this error when opening an OData Feed in Microsoft Excel 2010: 
 
Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: Object must implement IConvertible.
The current operation was cancelled because another operation in the transaction failed.
Out of line object 'DataSource', referring to ID(s) '2f58e13c-fa8a-4b49-803f-2df1d4fcca2f', has been specified but has not been used.
Out of line object 'DataSourceView', referring to ID(s) 'Temp_DSV', has been specified but has not been used.
 
Update to at least Excel 2013 or Tableau 8.3
 
Alternative Solution:
  1. Open the query
  2. Select the Set Sort and Group Options tab
  3. Remove the existing sort order of Last Name (ASC)
  4. Add a Sort order of Ask Amount (DESC)
  5. Save the query
  6. Try the OData feed again in Excel

Environment

 3.18

Was this article helpful?