Issue
Some BigQuery datasets may be missing when trying to list them in Tableau Desktop.
Last Modified Date: 26 Mar 2021
Environment
- Tableau Desktop
- Google BigQuery
Resolution
A possible workaround is to use the following steps in Tableau Desktop, after selecting the BigQuery connector and signing in with Google in the browser:- From the Project drop-down list, select publicdata.
- From the Dataset drop-down list, select samples.
- Under Table, double-click 'New Custom SQL'.
- In the Edit Custom SQL dialog, enter a query using the syntax below and then click OK:
SELECT * FROM `project-id.dataset_name.table_name`
Cause
This is a default behavior with a workaround as shown above.Additional Information
See latest TFS 1134679 where the connectivity team decided that not everyone would want the projects to be listed, so this is a Feature Request.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