KNOWLEDGE BASE

"An error occurred while communicating with the Google BigQuery data source <table name>"


Published: 14 Sep 2018
Last Modified Date: 15 Sep 2018

Issue

When running certain kinds of queries, you can connect to tables and run queries that return small amounts of data, but if you try to return a larger amount of data or create an extract you will run into an error like this:

An error occurred while communicating with the Google BigQuery data source <table name>.

Bad Request: The data source does not contain the expected data.

The Google BigQuery service could not find the resource you requested.

Not found: 'Job my-bigquery-project:job_Erzu5gY768_5A7Q6m_46q1j’

Note! This issue only affects data sets stored in Google BigQuery outside of North America and Europe.

 

Environment

  • Tableau Desktop
  • Tableau Server
  • Tableau Online
  • Tableau Public
  • Tableau Prep
  • Google BigQuery

Resolution

Tableau Development engineers are working on correcting this problem.

As a temporary workaround, move your data to a different data storage location.

Cause

Google has introduced a feature which is currently incompatible with Tableau data storage technology in certain ways. Google BigQuery users are now allowed to create data sets in different regions (North America, Europe, recently Japan and soon London). For more information, see Google Cloud --> Data Analytics Products --> Data Locations 

Data locations have been set up in such a way, that Tableau must query for and then pass in the data set location when using the Big Query Jobs API. Users can connect to tables and run queries that return small amounts of data, since those do not use the Jobs API, but if you try to return a larger amount of data or create an extract, you will run into an error because Tableau will use the Jobs API.
Did this article resolve the issue?