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

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