KNOWLEDGE BASE

Refreshing extracts of Google Big Query data source on Tableau Cloud failed since the beginning of April 1st 2022


Published: 20 Apr 2022
Last Modified Date: 08 Jun 2022

Issue

Refreshing extracts of Google Big Query data source failed since the beginning of  April 1st 2022 with the following error:

The Google BigQuery service reported an unrecognized error when processing this request. Request had insufficient authentication scopes. Insufficient Permission Unable to connect to the Google BigQuery server "". Check that the server is running and that you have access privileges to the requested database

Note that this error could also occur when the live connection to Google BigQuery datasource.

Environment

  • Tableau Cloud 2021.4.3
  • Google BigQuery

Resolution

Follow the steps in Additional Information in OAuth Security Improvements Requiring Reauthentication in Tableau Cloud (*1).
If the refresh extracts keeps failing, please republish the datasource (or the workbook, in which data source is embedded) with Authentication "Embedded password".

User-added image

This will get Tableau Cloud site to use the managed keychain as a credential for connecting GoogleBigQuery datasource. 
You can confirm if the managed keychain is used or not from the "Edit Connection".

User-added image

Cause

This is due to security improvements being made for some OAuth authenticated data sources in Tableau Cloud.
Did this article resolve the issue?