Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am trying to use the newly added Excel add-in to start working with this sort of report. However, I am getting an error message when I try to connect to Qlik with Excel in Office365.
On the other hand, from the OAuth side, I have this configuration.
Does anyone know what am I missing?
Thanks a lot!
Accepted Solutions
Suggest creating another oAuth client and ensure you have set the attributes properly.
Start with a broad scope to begin with (use 'user default'. you can narrow the scope later)
(based on your image you do not have use default at all. this is a requirement)
Recheck all the steps shown below to ensure they are setup accurately.
Creating an OAuth client for the Qlik add-in for Microsoft Excel
An OAuth client configuration is required to install the Qlik add-in for Microsoft Excel. The add-in is used by report developers to prepare report templates which control output of tabular reports from the Qlik Sense app.
For OAuth to work in the add-in, the OAuth client needs to be configured with the exact configuration shown below.
Do the following:
-
In the Management Console in Qlik Cloud, go to OAuth.
-
Click Create new.
-
In the Client type dropdown menu, select Single-page app. More fields will appear.
-
Insert a Name. The Description is optional.
-
At minimum, select the checkbox to include the user_default scope. You can include other scopes in the configuration, but without user_default, installation will not work.
See Creating an OAuth client for a full description of each available scope.
-
In the Add redirect URLs field, insert the URL of your tenant, followed by the fixed string: /office-add-ins/oAuthLoginSuccess.html
The result should look like this: https://YourServer/office-add-ins/oAuthLoginSuccess.html
-
Click Add.
-
In the Add allowed origins field, insert your tenant URL and click Add.
-
Click Create.
-
The Copy your Client ID window appears. You can choose to copy the Client ID to clipboard, or click Done to close the window.
After you have created the OAuth client, obtain the link to the updated manifest XML file from the Management Console. Go to the Settings page, and navigate to Feature control > Excel add-in within the Management Console. Use this link to deploy and install the add-in.
For additional example setup, refer to this image below.
Suggest creating another oAuth client and ensure you have set the attributes properly.
Start with a broad scope to begin with (use 'user default'. you can narrow the scope later)
(based on your image you do not have use default at all. this is a requirement)
Recheck all the steps shown below to ensure they are setup accurately.
Creating an OAuth client for the Qlik add-in for Microsoft Excel
An OAuth client configuration is required to install the Qlik add-in for Microsoft Excel. The add-in is used by report developers to prepare report templates which control output of tabular reports from the Qlik Sense app.
For OAuth to work in the add-in, the OAuth client needs to be configured with the exact configuration shown below.
Do the following:
-
In the Management Console in Qlik Cloud, go to OAuth.
-
Click Create new.
-
In the Client type dropdown menu, select Single-page app. More fields will appear.
-
Insert a Name. The Description is optional.
-
At minimum, select the checkbox to include the user_default scope. You can include other scopes in the configuration, but without user_default, installation will not work.
See Creating an OAuth client for a full description of each available scope.
-
In the Add redirect URLs field, insert the URL of your tenant, followed by the fixed string: /office-add-ins/oAuthLoginSuccess.html
The result should look like this: https://YourServer/office-add-ins/oAuthLoginSuccess.html
-
Click Add.
-
In the Add allowed origins field, insert your tenant URL and click Add.
-
Click Create.
-
The Copy your Client ID window appears. You can choose to copy the Client ID to clipboard, or click Done to close the window.
After you have created the OAuth client, obtain the link to the updated manifest XML file from the Management Console. Go to the Settings page, and navigate to Feature control > Excel add-in within the Management Console. Use this link to deploy and install the add-in.
For additional example setup, refer to this image below.
