Forum Discussion
Errors: No OAuth token with Google Drive scope was found.
I get an error (see below) when connecting BI to a view in bigquery that uses a table where the source is a google sheet on google drive. I appear to have permissons to the google drive and can acce...
Do you found any solution? Because I am having the same issue also.
Not much of a solution but as a quick workaround you can copy the content of the external Google Sheets table into a native BigQuery table with a scheduled query.
You can write the following query on the BigQuery UI:
SELECT * FROM `project.dataset.external_table`
Then schedule the query to run daily or hourly, and override the table `project.dataset.native_table`.
Finally, replace references to 'external_table' with 'native_table' in the view.