Connectivity between Office 365 SharePoint and Qlik Sense

[balajibc64]

Hi, I'm using Qlik Sense May 2024 Version. I need to access the Office 365 SharePoint from Qlik Sense. 

Kindly suggest how to create connections, what could be the Base URL and Prompt/Consent level etc. 

[Alan_Slaughter]

Hi maybe this link would be helpful to you:

https://help.qlik.com/en-US/connectors/Subsystems/Integrated_Web_Connectors_help/Content/Connectors_...

[balajibc64]

@Alan_Slaughter Thanks I will check and get back to you if anything required. 

[balajibc64]

Hi @Alan_Slaughter Below are the steps i did. 

1. Opened the Qlik Sense Hub 

2. Create a new app and try to create new connection. 

3. While creating the new connection, I choose office 365 sharepoint connectors 

4. After that, I gave the base sharepoint url. Then I choose select_account under Prompt level. 

5. Then try to authenticate. once authenticate another window opened with key.

6. I copied that key and pasted in the respective key and verify

7. Then its shows 

Status: Authenticated

User: XXX

Created: 25 Mar 2025 12:45:31

Expires: N/A

8. After that when i tried to click test connections, I'm facing issue. 

"Failed on attempt 1 to GET. (Message: The remote name could not be resolved: 'XXX.sharepoint.com')" 

Kindly suggest.  Thanks. 

[Alan_Slaughter]

Try disabling Proxy, VPN etc to ensure the network is fine.

[diegozecchini]

You're using select_account, which is fine for testing or multiple users. If you're doing this on a server or for unattended access, consider using:

none → No prompt, uses last logged in session

consent → To trigger consent screen if needed

But for most dev/test scenarios, select_account is OK.

[balajibc64]

@Alan_Slaughter Proxy and all disabled. Network is fine. I didn't connect VPN

[balajibc64]

@diegozecchini Ok. I'm connecting from my system, it means not inside the Qlik server.

[KalmerKaljuste-BeTerna · Accepted solution]

To fix this issue please add the *.sharepoint.com and *.microsoft.com to your internet options.
To do that do the following steps:
1) press on the "windows" button and search for internet options - open it.
2) Navigate to "connections" tab
3) Press on the Add VPN and add 2 separate lines:
*.sharepoint.com
*.microsoft.com
4) Select one of these newly created VPN connections and select the Settings
5) You might want to tick the "Automatically detect settings" or use automatic configuration script.

Please discuss this with your IT before as there could be already some settings that might conflict with the newly added settings. Also you might want to check if it's within the companies security policy to do so.

I would recommend to quickly test it out, disable or remove them and then discuss it with your IT.

[balajibc64]

@KalmerKaljuste-BeTerna Great. Thanks. Its showing connection succeed. 🙂  I followed the above steps you mentioned. I will proceed further and let me know if anything required. Thanks Much. 🙂