KNOWLEDGE BASE

NUMERIC Type BigQuery Fields Missing in Tableau Desktop


Published: 19 Jun 2018
Last Modified Date: 08 Sep 2020

Issue

When connecting to a Google BigQuery table that has columns of NUMERIC type, the NUMERIC fields and data do not appear in Tableau Desktop.

Environment

  • Tableau Desktop
  • Google BigQuery

Resolution

Upgrade to Tableau Desktop 2020.3. This version will natively convert NUMERIC to Double.

As a possible workaround, use Custom SQL to cast the NUMERIC field into FLOAT64. For more information, see Changing a Column's Data Type at BigQuery. 
 
Did this article resolve the issue?