SQL Server Text Fields Have a 1024-Character Limit
Published: 11 May 2013
Last Modified Date: 26 Aug 2019
IssueWhen a Microsoft SQL Server text dimension is used in a Tableau Desktop view, only 1024 characters display.
- Tableau Desktop
- Microsoft SQL Server
ResolutionTry one of the following workarounds:
- Connect to SQL Server using a generic ODBC connection. On the Connect to Data page, select Other Databases (ODBC).
- Change the field type in the MS SQL Server to VARCHAR(MAX) or NVARCHAR(MAX)
CauseThis character limit is specific to Microsoft SQL Server. Character limits vary depending on the database and driver combination.