Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The problem occurs when using the Google BigQuery connector (part of the ODBC Connector Package) with user authentication.
The connector is not able to fetch data and it fails also when the connection is tested. The reloads fail with this error message:
Authentication failed: invalid_grant.
The problem occurs even after applying the workaround for the OAuth out-of-bound flow deprecation described in this article and after the upgrade to Qlik Sense May 2022 SR8 or higher releases that have this fix incorporated.
The solution consists is substituting the qsdfw_qsefw.qliksourceconfig file in the failing environment with a correct one.
If this solution cannot be applied, a possible workaround is to use the driver directly with a system DSN. To do this it is necessary to configure a Simba Google BigQuery ODBC Connector on the machine.
The problem is currently under investigation (QB-16841). It is possible that the qsdfw_qsefw.qliksourceconfig file in C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage is not update correctly when the workaround is applied or when Qlik Sense is upgraded. This may be due to strict security settings on the environment.
See this article.
QB-16841