1 Reply Latest reply on Aug 27, 2018 4:26 PM by Patrick A Van Der Hyde

    An OData Date Time field is NULL on Refresh but not when

    ICT Support

      I have an OData data source which returns a very simplistic list of objects (see below)

       

       

      {

         "value": [

        {

         "Output": 712,

         "Name": "Location x",

         "Unit_Id": 10,

         "ReportedOn": "2018-08-08T17:04:56.0000+10:00"

        }

      ]}

       

       

      Here is the schema as advertised by the OData server.

       

      <EntityType Name="X">

      <Key> </Key>

      <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"/>

      </EntityType>

       

      (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?