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>
Last modified date: 07 Jun 2023
Environment
- Tableau Desktop
- Google BigQuery
Resolution
- 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`.
- 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.Thank you for providing your feedback on the effectiveness of the article.
Open new case
Continue searching
Knowledge Base
Community
Product help
Training and tutorials