Excel-Add In | Always ask for Qlik login data

[Mara_mamaco]

Hello everyone,

I am trying to change the Redirect URL of the OAuth client for the Excel-Add in such a way that a query of the Qlik login data is always requested without the automatic login via the Microsoft AD.

Background: An extra Microsoft Qlik-user is used as a professional who does not have a Microsoft license. However, the user with the Microsoft license has no access to Qlik.

So far I have found the prompt: “&prompt=select_account”, which I cannot simply write after the standard redirect URL “https://tenant.de.qlikcloud.com/office-add-ins/oAuthLoginSuccess.html”.

Many thanks in advance for your suggestions.

[Ruggero_Piccoli]

Hi,

I think your scenario is not very clear. Could you add some details?

The credentials request is done the first time you log into the Add-In. After it enters directly with previous user. 

Best Regards,

Ruggero

[Mara_mamaco]

Hi Ruggero,

thank you for your quick reply.

Hopefully the example below explains my issue little bit better:

I have one responsible employee for the Qlik Cloud professional User: John. John has his Microsoft credentials "John@example.com". For the Qlik Cloud however he uses the Microsoft Account "Qlik@example.com". Johns Microsoft User has no role or authorization in the Qlik Cloud.

The Qlik Cloud uses Microsoft Azure AD for SSO. In the Qlik Cloud he has the opportunity to log in with the User "Qlik@example.com", but the Excel Add-in uses the Azure AD information "John@example.com" automatically, because he is already logged in into his microsoft user. There is no credential request the first time he logs in, because his user is part of the Microsoft Azure AD.

He can log in into the Excel Add-in, but has no possibility to use and/or see any data:

I'm basically looking for a way to either:

• Log in/log out from the Excel-Add in manually
• or create a way that Microsoft doesn't use the Azure AD Login information automatically

[Frank_S]

Hi there. 

You may have already seen this but will re-share in case you have not.

First, if you need to configure a 3rd party IDP to access Qlik Cloud, then you an use the following help pages to guide you.

• https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/mc-create-idp-conf...

You can use custom groups and permissions to setup access as needed.

• https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/permissions-custom... (user based)
• https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/mc-managing-groups...
• https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/SaaS-user-manageme... (capacity based)

Once you have refined your access as per above, then use the standard oauth configuration to complete the add-in configuration.

• https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/add-in-excel-i...

If you have further complex, requirements, it may be a good idea to reach out to your Qlik Account Manager who can arrange a Qlik Professional Services engagement in order to iterate your requirement directly with you and build out your custom requirement as needed. Consider this path if the above or others here are unable to provide you with a suitable solution.

Kind regards.