title: How can I solve the error "Dataset was not found in location US" in BigQuery?
body: <p>I'm trying to run some tests with Google BigQuery to calculate data from my Google Spreadsheets. When trying to run the code, I am getting the error: "Dataset was not found in location US".</p>
  
  <p>I have already tried processing the site in "Automatic" or "EU" in the query settings but neither of each has brought any useful results.</p>
  
  <p>The code I used is this one here:</p>
  
  <pre><code>SELECT a.Customer AS Customer,
         round(100.00*sum(b.Online_Sales)/sum(a.Sales), 2) AS PctOnlineSales
  FROM
      Dataset.Big_Data_Test_1_Sales a
  JOIN
      Dataset.Big_Data_Test_1_Online_Sales b
  ON a.Customer = b.Customer
  --WHERE a.Customer IN ('1002')
  GROUP BY 1
  ORDER BY 1
  </code></pre>
  
  <p>I expected to multiply the data of two sheets that are schemed in my dataset. </p>
  
  <p>Can you guys help me fix the location issue?</p>
  
  <p>Thanks in advance!
  Nes</p>