KNOWLEDGE BASE

NUMERIC Type BigQuery Fields Missing in Tableau Desktop and Tableau Server


Published: 19 Jun 2018
Last Modified Date: 22 Apr 2021

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 and Tableau Server

Environment

  • Tableau Desktop
  • Tableau Server
  • Google BigQuery

Resolution

Upgrade to Tableau Desktop and/or Tableau Server 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?