String Type fields shows empty value when using live connection via Tableau Bridge linux to MS SQL Server.

Tableau / Tableau Cloud
In Review

Created

Jan 23, 2025

Found in Release

2024.3

Last Updated

Jan 24, 2025

Reference ID

W-17632936

Summary

String Type fields shows empty value when using live connection via Tableau Bridge linux to MS SQL Server.


Collations in MSSQL Server which can cause this issue:

  • Japanese_BIN2
  • Japanese_CI_AS


The issue only happens with String type field with remote type "ANSI/MBCS character string."


Note:

  • VARCHAR (or CHAR) is used for ANSI/MBCS character strings.
  • NVARCHAR (or NCHAR) is used for Unicode character strings.

Steps to Reproduce

(Prepare "Tableau Bridge on Linux" for connecting to on-premise Microsoft SQL Server)


1.Create a data source that connects to on-premise Microsoft SQL Server with live connection on Tableau Desktop:


For example a table architecture and data:


Table: name VARCHAR(50), char CHAR(1), nchar NCHAR(1), nvarchar NVARCHAR(50), id INT, PRIMARY KEY (id)

Data: 'banana', 'A', 'A', 'banana', 1


2.Publish the data source from Tableau Desktop to Tableau Cloud.


3.Create a new workbook with the published datasource in step 2.


4.Note that the "Remote type" of string fields (field name: nvarchar) is "Unicode character string" and the data is displayed as "banana":

Unicodechar.png


5.Note that the "Remote type" of string fields (field name: Name) is “ANSI/MBCS character string” and data is empty:

ANSIMBCS.png

Workaround

Use Tableau Bridge on Windows instead.

Reference IDW-17632936
In Review

2 Reports

2 Reports