2 Reports
String Type fields shows empty value when using live connection via Tableau Bridge linux to MS SQL Server.
Created
Found in Release
2024.3
Last Updated
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":
5.Note that the "Remote type" of string fields (field name: Name) is “ANSI/MBCS character string” and data is empty:
Workaround
Use Tableau Bridge on Windows instead.
2 Reports