BQ Token Timeout – Tableau

SimonaDatacop · 02-10-2025 05:24 AM

We use Tableau Server to visualize data stored in Google BigQuery. Our data extracts are created within Tableau and refreshed daily. However, we recently started encountering an error due to extract refresh failures.

I reached out to Tableau Support, but they believe the issue is related to Google BigQuery, specifically token expiration.

Has anyone encountered a similar issue or can offer any insights? We've tried multiple approaches, including using a service account, but nothing has resolved the problem so far.

Error Message bigquery.googleapis.com: {"error":{"code":404,"message":"Request couldn't be served.","errors":[{"message":"Request couldn't be served.","domain":"global","reason":"notFound"}],"status":"NOT_FOUND"}}
Tableau Error Message :Unknown Failure ( status code = 1000, Internet communication error: Failure when receiving data from the peer.

ruthseki

Hi @SimonaDatacop,

Welcome to Google Cloud Community!

According to this documentation, the error message you’re seeing related to Big Query with error code 404 signifies that:

This error returns when you refer to a resource (a dataset, a table, or a job) that doesn't exist, or when the location in the request does not match the location of the resource (for example, the location in which a job is running). This can also occur when using table decorators to refer to deleted tables that have recently been streamed to.

To troubleshoot this:

Fix the resource names, correctly specify the location, or wait at least 6 hours after streaming before querying a deleted table.

If the issue still persists you may contact Google Cloud Support for assistance or file a report through the issue tracker. This way you could have visibility on the progress of your case as it is publicly available. Please note that I can't provide any details or timelines at this moment. For future updates, I suggest keeping an eye out on the issue tracker.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

SimonaDatacop

Hello @ruthseki ,
Thank you for the information. However, Tableau is attempting to access tables that do exist in BigQuery. Each time the data source is refreshed in Tableau, it tries to connect to the BigQuery table using either OAuth access tokens or the service account key. Despite this, BigQuery returns a 404 error, even though the tables haven’t been deleted.
We don’t use time decorators and rely on Dataform to create and update our BigQuery tables.
Do you have any idea why this error might be occurring?

SimonaDatacop

Hello @ruthseki, I hope you're doing well. I wanted to follow up as I haven’t received a response from you yet. Could you kindly review my previous message?
Looking forward to your reply. Thanks!