KNOWLEDGE BASE

Error "Custom SQL relation refers to a non-existent parameter" Connecting to Published Data Source


Published: 09 Jun 2017
Last Modified Date: 20 Nov 2017

Issue

When connecting to a published data source using custom SQL joined to multiple tables, the following error might occur: 
"Custom SQL relation refers to non-existent parameter"

Environment

Tableau Desktop 10.0.0 - 10.0.10 

Resolution

Option 1: 

Upgrade to Tableau Desktop 10.0.11 or a newer version. 

Option 2:

As a workaround, include the joins in the custom SQL rather than joining separately. 

Cause

This behavior is related to a known issue with ID 646508 which has been corrected in more recent versions. 
Did this article resolve the issue?