KNOWLEDGE BASE

Unable to Render Dimension Members With Case Sensitivity for MySQL When using Custom SQL


Published: 20 Sep 2017
Last Modified Date: 21 Sep 2017

Issue

When connecting to MySQL, case-sensitive table collation is ignored when custom SQL is used and the query is modified to Upper case. Custom SQL connections to MySQL now defaults to database collation.

Environment

  • Tableau Desktop 10.1.6
  • OSX + Server
  • MySQL

Resolution

Upgrade to Tableau Desktop 10.3.3 ; 10.2.5 ; 10.1.11 or 10.0.13. For more information, see Upgrading Tableau Desktop in Tableau Help.

Cause

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