KNOWLEDGE BASE

Error "No OAuth token with Google Drive scope was found" When Connecting to BigQuery


Published: 17 Feb 2017
Last Modified Date: 31 Jul 2020

Issue

When connecting to Google BigQuery, the following error may occur:
Bad Request: The data source does not contain the expected data.
The Google BigQuery service has denied access for this request.
Access Denied: BigQuery BigQuery: No OAuth token with Google Drive scope was found.

Environment

  • Tableau Desktop
  • Google BigQuery (with tables referencing data stored in Google Sheets)

Cause

The ability to connect to BigQuery tables that reference data stored in Google Sheets is currently not built in the product.
Did this article resolve the issue?