KNOWLEDGE BASE

Error "Tableau Data Engine Error: 49035: join expressions must have the same data type" When Replacing Data Source


Published: 15 Jul 2016
Last Modified Date: 03 Oct 2017

Issue

When replacing a published data source with a local copy, the following error might occur: 

Tableau Data Engine Error: 49035: join expressions must have the same data type

Environment

Tableau Desktop 9.0 - 9.3
 

Resolution

Option 1: 

Upgrade to Tableau Desktop 9.3.7 or a newer version. For more information, see Upgrading Tableau Desktop.

Option 2: 

Replace any Level of Detail (LOD) calculations in the data source with row-level calculations. 
 

Cause

This behavior is related to a known issue that has been corrected in a recent version.
Did this article resolve the issue?