Error: Cannot connect to the specified feed. Verify the connection and try again. Reason: The remote server returned an error: (500) Internal Server Error - when connecting to Odata

You may encounter the followings error when connecting to an Odata link through Excel Powerpivot when a smart field is included in the output: Cannot connect to the specified feed. Verify the connection and try again. Reason: The remote server returned an error: (500) Internal Server Error
This is caused by the query name beginning with a number. Edit the query name in Altru to rename the query to not begin with a number. 

Environment

 4.1

Was this article helpful?