NUMERIC Type BigQuery Fields Missing in Tableau Desktop

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.

Additional Information

To voice your support for the inclusion of this enhancement in a future product release, add your vote to the following Community Idea: Support NUMERIC type from BigQuery.

Discuss this article... Feedback Forum