KNOWLEDGE BASE

Error "The Google BigQuery Service has denied access for this request" Appears For Specific Users When Viewing Dashboard


Published: 24 Jul 2019
Last Modified Date: 20 Jul 2021

Issue

When a specific user views a workbook which uses Google BigQuery as a data source, the following error appears:
The Google BigQuery service has denied access for this request.
Access Denied: Project <project name>: The user <user email> does not have bigquery.jobs.create permission in project <project name>.
Unable to connect to the Google BigQuery Server "googleapis.com/bigquery:. Check that the server is running and that you have access privileges to the requested database.  

Environment

  • Tableau Online
  • Google BigQuery

Resolution

Try the following solutions to possibly resolve the issue:

Option 1

Remove the BigQuery credentials with the account that is experiencing the issue in Tableau Online (My Account Settings > Saved Credentials)

Option 2

Ensure the bigquery.jobs.create and bigquery.jobs.view permissions are enabled for all users who are accessing the view in the Google BigQuery permissions.

For more information, please see: https://cloud.google.com/bigquery/docs/access-control

Cause

This may be related to the lack of permission for the users on Google BigQuery.
 
Did this article resolve the issue?