Google BQ connector error when reloading data stored in Google Sheets

Polina — Fri, 01 Sep 2023 08:54:20 GMT

Dear community,

I have a table in Big Query referencing data stored externally in Google Sheets. When I try to query this data through BigQuery connector, I am getting an error "Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials." I have already tried the solution described here: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Google-BigQuery-connector-error-quot-Access-Denied-BigQuery/tac-p/2112023#M10043, however it did not help me. My BigQuery account does have access to the corresponding Google Sheets and querying from BQ goes without a problem. However, in Qlik I don't even see the tables referencing these sheets under the list of tables in the connection. Has anybody here experienced a similar problem? Is there anything extra that needs to be done or updated besides adding RequestGoogleDriveScope in Advanced settings, which I have already done?

topic Google BQ connector error when reloading data stored in Google Sheets in Connectivity & Data Prep

Google BQ connector error when reloading data stored in Google Sheets