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

As a possible workaround, use Custom SQL to cast the NUMERIC field into another data type, for example INT or FLOAT. For more information, see Changing a Column's Data Type at BigQuery.

Cause

BigQuery's NUMERIC type is currently not recognized by Tableau.

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