問題
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>
上次修改日期 : 07 Jun 2023
環境
- Tableau Desktop
- Google BigQuery
解決方法
- 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.
原因
One of the fields currently configured as a number data type contains a string value.感謝您針對本文的效益提供意見回饋。
開啟新案例
繼續搜尋
知識庫
社群
產品說明
訓練及教學課程