Loading

Error "Google BigQuery service was unable to compile the query. Unrecognized name: `person.name.first`" Occurs When Connecting to Google BigQuery from Tableau Desktop

Publiceringsdatum: Dec 23, 2025
Beskrivning

When connecting to BigQuery data source from Tableau Desktop then receives error:
 

The Google BigQuery service was unable to compile the query. Unrecognized name: `person.name.first` at [1:37]

Cause

This is an issue within Google BigQuery. 

 

Lösning

Option 1

Fields must contain only letters, numbers, and underscores, start with a letter or underscore, and be at most 128 characters long.


Option 2

When connecting to Google BigQuery, select the "Use Legacy SQL" option in Tableau Desktop. For more information, see Check if your workbook uses standard SQL or legacy SQL in Tableau Help.

 

Ytterligare resurser

See the Google BigQuery issue in the Google Issue Tracker. 

 

Knowledge-artikelnummer

001498346

 
Laddar
Salesforce Help | Article