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

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)

Resolution

A possible workaround is to select * from the federated table and load the data into a native table in BigQuery, and then connect Tableau to the native table.

For more information, see Bad Request: The data source does not contain the expected data (BigQuery) and BigQuery Credential Problems when Accessing Google Sheets Federated Table in the Tableau Community Forums.