KNOWLEDGE BASE

Connecting to Data Source with DateTimeOffset Data Type


Published: 11 Aug 2014
Last Modified Date: 26 Jul 2016

Issue

When connecting to a data source, columns with a DateTimeOffset data type are not imported into Tableau Desktop.

Environment

  • Tableau Desktop
  • MS SQL Server

Resolution

Option 1

In the database, change the data type to a supported format.

Option 2

Import the field into Tableau Desktop using custom SQL to convert the field during connection.

Cause

Tableau Desktop does not recognize the DateTimeOffset data type.
Did this article resolve the issue?