KNOWLEDGE BASE

Date Fields Interpreted as String on MS SQL data source


Published: 18 Apr 2022
Last Modified Date: 19 Apr 2022

Issue

When connecting Tableau Server to a Microsoft SQL Server database, date fields may be interpreted as text fields.

Environment

  • Tableau Server
  • Windows
  • MS SQL Server 2016

Resolution

Uninstall older versions of Microsoft ODBC Driver for SQL Server (e.g. SQL Server Native Client 10.0) and install Microsoft ODBC Driver for SQL Server 17.7.2, which you can download from:
https://go.microsoft.com/fwlink/?linkid=2156851

Cause

Incorrect driver version in use.
Did this article resolve the issue?