Google BQ connector error when reloading data stored in Google Sheets
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-Ac... 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?
