Error: Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: The remote server returned an error: (401) Unauthorized.. An error occurred while processing table 'Data Feed Cont

 When importing Odata into Excel one may receive the following error: Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: The remote server returned an error: (401) Unauthorized..
 
An error occurred while processing table 'Data Feed Content'.
 
The current operation was cancelled because another operation in the transaction failed.
 
Out of line object 'DataSource', referring to ID(s) 'adc7429d-4ba2-42a6-b2e6-b425d6fdc86d', 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.
This is due to outputting the Country field in a Sales Order query and looking at an extended period of time. 

To correct: If you are looking at Sales Orders that are one year or older in OData, edit your query to not include Country in your results.

Environment

 4.1

Was this article helpful?