Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
DavidPROVOST's avatar
DavidPROVOST
Icon for Advocate III rankAdvocate III
6 years ago

Hey DBrownlow. Same problem here. Did you get through this ?

Simiar problem occur when trying to read Google sheet directly from Power BI : Works fine with a public access GSheet, but fails if authentication is required. Funny, as I already have a Google OAuth Token with BigQuery. GSuite tokens differ from GCP Tokens ?

 

I'll read the provided article.

andylai's avatar
andylai
New Member
6 years ago

Do you found any solution? Because I am having the same issue also.

  • Héctor's avatar
    Héctor
    New Member
    5 years ago

    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.