Loading

"Error Code: 015CFBE6 The Google BigQuery service was unable to compile the query. Bad double value" Querying Google BigQuery from Tableau

Дата публикации: Feb 4, 2025
Описание

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>

 

Cause

One of the fields currently configured as a number data type contains a string value.

 

Решение
  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.

 

Номер статьи базы знаний

001534465

 
Загрузка
Salesforce Help | Article