KNOWLEDGE BASE

Fields with TIME Data Type Not Imported Into Tableau Desktop for MS SQL Server


Published: 29 Aug 2013
Last Modified Date: 03 Jan 2024

Issue

When you connect to Microsoft SQL Server data sources, fields with the data type TIME do not show up in Tableau Desktop.

Environment

  • Tableau Desktop
  • Microsoft SQL Server

Resolution

Work with your database administrator to change the field to a datetime format or to type VARCHAR in the database.

Cause

Tableau Desktop does not currently support native Time types.
Did this article resolve the issue?