I have an OData data source which returns a very simplistic list of objects (see below)
"Name": "Location x",
Here is the schema as advertised by the OData server.
<Property Name="Output" Type="Edm.Int32" Nullable="false"/>
<Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="500"/>
<Property Name="Unit_Id" Type="Edm.Int32" Nullable="false"/>
<Property Name="ReportedOn" Type="Edm.DateTimeOffset" Nullable="false"/>
(Copy/paste job with some edits)
Post creating a new worksheet and adding the the data source - I then apply the fields to a line chart which results in the ReportedOn field being populated with data.
When we perform a refresh of the data, either when building the report or when consuming the report with Tableau Online, the ReportedOn field turns to a NULL value.
The underlying data type does not change - only a new set of data.
All the reading that I've been performing over the past few days points to a lack of support for the returned data time format which I find extraordinary. The underlying databases for the OData end points is both Oracle and MSFT Sql Server.
However, when I use a static Json file, there doesn't seem to be a problem with refreshes.
What am I doing wrong?