KNOWLEDGE BASE

Null Values Appear as Blank in the Filter Card and Cannot be Selected When Connecting to MySQL


Published: 18 Feb 2022
Last Modified Date: 27 Apr 2022

Issue

When working with a live MySQL connection and a field has Null values, these values show as blank in the filter card. They also cannot be selected from the filter and will only appear in the view if the filter is set to 'All values'.

User-added image

Environment

  • Tableau Desktop 
  • MySQL with ODBC driver 8.0.27 and above

Resolution

Install MySQL ODBC driver version 8.0.26: https://downloads.mysql.com/archives/c-odbc/
 

Cause

This issue is happening with MySQL ODBC driver version 8.0.27 and above. It has been observed on Windows and Mac across all versions of Tableau.
Did this article resolve the issue?