1 Reply Latest reply on Aug 27, 2018 4:26 PM by Patrick 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"/>



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