Error "Bad int64 value" Using FLOAT() on a String field in Google BigQuery
Published: 24 Nov 2016
Last Modified Date: 30 Jan 2017
IssueUsing FLOAT () on a string field containing a decimal separator (ex: 12345.67), the following error occurs:
Bad int64 value 12345.67
- Tableau Desktop 10.1.0 - 10.1.2
- Google BigQuery
Upgrade to Tableau Desktop 10.1.4 or a newer version. For more information, see Upgrade Tableau Desktop.
RAWSQL_REAL("CAST (%1 AS FLOAT64)", [DimensionName])
CauseThis behavior is related to a known issue which has been corrected in more recent versions.