Section access

[QS21]

Hi all,

I am using qliksense in GCP platform and am trying to perform section access for a global report. I have developer access and the connection that I use is OATH. The person's ID with which the connection created also has ADMIN level access and is included in the section access file.

We have created a Big Query table with the section access excel file. Made sure everything in file is CAPS. Ex:

USERID	USER_NAME	ACCESS	COUNTRY	USER_ACTIVE	DASHBOARD_NAME
ABCD\12345454	ABCDEF	ADMIN	*	Y	XYZ
ABCD\09799000	SSIII	ADMIN	*	Y	XYZ
ABCD\45643576	JKJVKJ	USER	IN	Y	XYZ
ABCD\34533454	SSSOL	USER	SG	Y	XYZ
INTERNAL\SA_SCHEDULER		ADMIN	*	Y	XYZ

LIB CONNECT TO 'Google_BigQuery_*******;
SECTION ACCESS;
LOAD USERID,
USER_NAME,
ACCESS,
COUNTRY,
USER_ACTIVE,
DASHBOARD_NAME;
[abcde]:
SQL SELECT `USERID`,
`USER_NAME`,
`ACCESS`,
COUNTRY,
`USER_ACTIVE`,
`DASHBOARD_NAME`

FROM `test`.`abc_test`
where USER_ACTIVE='Y' and DASHBOARD_NAME='xyz';
SECTION Application;

ERROR MESSAGE:

Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.

Data has not been loaded. Please correct the error and try loading again.

Please help!

[QS21]

AUTH**

[QS21 · Accepted solution]

SECTION ACCESS;
LOAD ACCESS,
 USERID,
 COUNTRY;

SELECT ACCESS,
USERID,
COUNTRY
FROM `test`.`abc_test`;
SECTION APPLICATION;

This worked!