KNOWLEDGE BASE

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


Published: 24 Jan 2018
Last Modified Date: 10 Sep 2020

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

Upgrade to Tableau Desktop 10.5.2 or later.
Or,
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 fixed in more recent versions of Tableau Desktop.
Did this article resolve the issue?