Bigquery can't retrieve data but can see schema due to wrong dataset location

[vatojavier]

I can retrieve all datasets and tables from Bigquery but when trying to actually get the data (preview or executing custom sql). It happens for Live connection and Elasticube.

I use a json service account file to authenticate and withing Google Cloud logging I see that Sisense is trying to fetch the data from US which is not the location the dataset is. I don't know how to fix it.

Google cloud log: when trying to fetch data:
"Not found: Dataset PROJECT_XX:dataset_xx was not found in location US"

[DRay]

Hello @vatojavier,

I have been asked to have you submit a support ticket for this. They will be able to review system logs and help you get answers for this.

Please let us know what you find out.

Have a great day!

[irismaessen]

My experiments with BQ were a while ago and I don't remember everything, but I do remember puzzling over this too.

In order to get Sisense to retrieve data from the correct BQ location, I had to specify  the location in the 'Additional Parameters' of the connection within Sisense; add there something like: location=US
(or wherever your data is located). I may also have had to set up an explicit LargeResultDataset (include the name of the dataset in the Additional Parameters in the same way as the location, separated by a semicolon)

Iris

[DRay]

Hello @vatojavier,

I wanted to check in with you to see if you were able to get this resolved.