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.