Issue
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]
Last Modified Date: 20 Jul 2023
Environment
- Tableau Desktop
- Windows 10
- Google BigQuery
Resolution
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.
Cause
This is an issue within Google BigQuery.Additional Information
See the Google BigQuery issue in the Google Issue Tracker.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