Published: 18 Dec 2019 Last Modified Date: 26 Mar 2021
Issue
Some BigQuery datasets may be missing when trying to list them in Tableau Desktop.
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.