title: "Failed to read the spreadsheet. Error code: PERMISSION_DENIED" - Tableau custom query
body: <p>I am working on Tableau 2020.2.
  I have a BigQuery table (TableA), fetching live data from Google sheet (Sheet1).
  When I am trying to connect the Google sheet directly in Tableau Data-source, it is getting connected. Also, when I am dragging and dropping the table(TableA) directly on the 'Drag tables here' in the data source, it is working fine.
  But when I am trying to run a custom query on the TableA, it is throwing the following error:</p>
  <pre><code>Bad Connection: Tableau could not connect to the data source.
  Error Code: 015CFBE6
  The Google BigQuery service was unable to process this request.
  Error while reading table: TableA, error message: Failed to read the spreadsheet. Error code: PERMISSION_DENIED
  
  </code></pre>