KNOWLEDGE BASE

Error "The Google BigQuery service was unable to compile the query. Bad double value"


Published: 23 Feb 2022
Last Modified Date: 25 Feb 2022

Issue

When querying a Google BigQuery data source (e.g. creating an extract, loading a visualization), the following error may occur:

Error Code: 015CFBE6
The Google BigQuery service was unable to compile the query.
Bad double value:
<string value>

Environment

  • Tableau Desktop
  • Google BigQuery

Resolution

  1. Determine which field the string value in the error message belongs to. One way to do so is to check the Tableau Desktop logs for the query that casts a field to number type, e.g. CAST(CAST(`Overall_SaleOrder`.`order_no` AS FLOAT64) AS INT64) AS `order_no`.
  2. Change the data type for this field to String instead.

Cause

One of the fields currently configured as a number data type contains a string value.
Did this article resolve the issue?