KNOWLEDGE BASE

Fail to create extract while pulling data from OData V2


Published: 02 Jun 2022
Last Modified Date: 02 Jun 2022

Issue

Unable to create an extract when connecting to an OData service.

Environment

  • Tableau Desktop 2021.1.
  • Windows
  • Odata

Resolution

Append the Server URL with "&$format=xml" without quotes to force the response from OData service to be in XML format. 
 

Cause

The response from OData was not recognized as XML format.

Additional Information

  • Tableau supports these OData versions and formats:
  • OData V1 and V2 – We support OData XML/Atom format for feed responses.
  • OData V4 and V4.01 – We support OData-JSON format for feed responses.
OData
Did this article resolve the issue?