KNOWLEDGE BASE

Error "collation mismatch, use COLLATE statements to resolve" When Using a Cross Database Join


Published: 24 Jan 2018
Last Modified Date: 15 May 2018

Issue

When performing a cross-database join involving a legacy Excel connection in Tableau Desktop 10.5, the following error might occur:

collation mismatch, use COLLATE statements to resolve. 

Environment

Tableau Desktop 10.5.0 and 10.5.1

Resolution

Try one of the following workarounds:

  • Use Legacy Connection for both files
  • Use Standard Connection for both files

Cause

This behavior is related to a known issue (ID: 733366) which is currently under investigation.
Did this article resolve the issue?