Missing BigQuery Datasets on Data Source Page

Published: 18 Dec 2019
Last Modified Date: 26 Mar 2021


Some BigQuery datasets may be missing when trying to list them in Tableau Desktop.


  • Tableau Desktop
  • Google BigQuery


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:
  1. From the Project drop-down list, select publicdata
  2. From the Dataset drop-down list, select samples
  3. Under Table, double-click 'New Custom SQL'. 
  4. 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`


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.
Did this article resolve the issue?