KNOWLEDGE BASE

Missing BigQuery Datasets on Data Source Page


Published: 18 Dec 2019
Last Modified Date: 11 Aug 2020

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:
  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`

Cause

This issue is currently under investigation.
Did this article resolve the issue?