KNOWLEDGE BASE

SQL Server Text Fields Have a 1024-Character Limit


Published: 11 May 2013
Last Modified Date: 27 May 2016

Issue

When a Microsoft SQL Server text dimension is used in a Tableau Desktop view, only 1024 characters display.

 

Environment

  • Tableau Desktop
  • Microsoft SQL Server

Resolution

A workaround that has been successful for some people is to connect to SQL Server using a generic ODBC connection. On the Connect to Data page, select Other Databases (ODBC).

 

Cause

This character limit is specific to Microsoft SQL Server. Character limits vary depending on the database and driver combination.

 

Did this article resolve the issue?