KNOWLEDGE BASE

Error "No such column error" When filtering 8+ Member Groups with a Custom SQL field


Published: 21 Jun 2018
Last Modified Date: 21 Jun 2018

Issue

When using custom SQL to declare a field that is used to group or filter at least 8 dimension members on a published live data source with multiple connections a "No such column" error may be displayed. 

Environment

  • Tableau Server 10.4.1
  • MS SQL Server with a live connection

Resolution

Option 1

Upgrade to Tableau Desktop 2018.1.2, 10.5.5, 10.4.8, 10.3.12 or a later version . For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

Change the live connection to an extract.

Cause

This behavior is related to a known issue (ID: 743018) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?