title: Understanding the "Not found: Dataset ### was not found in location US" error
body: <p>I know this topic has come up many times but still here I am. Data processing location seems consistent (dataset, US; query: US) and I am using backticks &amp; long format in the FROM clause</p>
  <p>Below are two sequences of code. The first one works perfectly:</p>
  <pre><code>SELECT station_id
  FROM `bigquery-public-data.austin_bikeshare.bikeshare_stations`
  </code></pre>
  <p>Whereas the following returns an error message:</p>
  <pre><code>SELECT bikeshare_stations.station_id
  FROM `bigquery-public-data.austin_bikeshare`
  </code></pre>
  <p>Not found: Dataset glassy-droplet-347618:bigquery-public-data was not found in location US</p>
  <p>My question, thus, is why do the first lines of text work while the second doesn't?</p>
  <p><a href="https://i.stack.imgur.com/iOBDF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iOBDF.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/oZSFJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oZSFJ.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/8Dkee.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8Dkee.png" alt="enter image description here" /></a></p>