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

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 a...