topic Re: Qlik sense sharepoint in Connectivity & Data Prep

Qlik sense sharepoint

dalshari — Fri, 02 Feb 2024 17:58:12 GMT

Hi to all,

we have issue with data connection on qlik sense system. Encrypted key were created. Data connection is able to authenticate, but when trying to create Sharepoint data connection we get error: "Failed on attempt 1 to GET. (Unable to connect to the remote server)"

all nodes are allowed for 443 and are able to access the sharepoint link directly from virtual machine. Sharepoint site/server is online. Authentification successful. Firewall and proxy setup correctly. network connectivity works.

Re: Qlik sense sharepoint

hugo_andrade — Fri, 02 Feb 2024 20:51:49 GMT

Hi @dalshari ,

Great info you provided on the server side. At first glance, this looks like a Data Connection issue.

Please share the Data connection details.
Thanks

Re: Qlik sense sharepoint

dalshari — Sat, 03 Feb 2024 16:25:04 GMT

Hi,

I follow standard way. Create new connection -> Data sources -> Office 365 Sharepoint Metadata.

Filling up the fields:

Based URL https://***.sharepoint.com

Prompt / consent level select_account

Next part, authentification - went thru smoothly.-> Your Authentication Code -> insert code -> verify -> all went ok. Once trying "test connection" than receiving mentioned error.

Wierd thing is, thru "web connector" it goes without any issue.

Re: Qlik sense sharepoint

Anil_Babu_Samineni — Sun, 04 Feb 2024 05:20:32 GMT

@dalshari I guess the encryption key you created / generated using service user (Like, your service running account, Example service account)?

Re: Qlik sense sharepoint

dalshari — Mon, 05 Feb 2024 08:57:34 GMT

Hello,

correct. Encrypted key were generated as per documentation under service user on all nodes.

Regards,

Re: Qlik sense sharepoint

hugo_andrade — Mon, 05 Feb 2024 12:09:01 GMT

@dalshari ,

No other attributes used? Subsites for example?

In an attempt to test on my side, I found an existing connection for reference. I'm using the values as per below:

Base URL: https://ipcglobal-my.sharepoint.com
Site/Subsite Path: empty
Tenant: common
Prompt/Consent level: select_account

Would you try the same example as per below and use your company name instead. One item to notice on the Base URL: it has a slight different format "-my.sharepoint.com".

Please give it a try using that format and let me know.

Also, please share your Server version. Since the connector differ from version to version, I want to make sure I'm using similar setup on my side.

Re: Qlik sense sharepoint

dalshari — Thu, 08 Feb 2024 15:29:01 GMT

Hello,

tested. Still fails with same error. 😞

Regards,

Re: Qlik sense sharepoint

hugo_andrade — Fri, 09 Feb 2024 19:15:24 GMT

Hi @dalshari ,

Also, please share your Server version. Since the connector differ from version to version, I want to make sure I'm using similar setup on my side.

Are you able to build this connection on another server or QS Desktop?

Trying to isolate some variables here.

Re: Qlik sense sharepoint

dalshari — Tue, 13 Feb 2024 16:05:15 GMT

Hello,

thank you for fast reply. The issue were solved by updating 2 config file withing qlik sense. But another issue came with in.

The connection get a "Connection succeeded" result for the connection test however when the little pencil is used to locate locate the file to load it into the script, an error message “An error occurred while parsing EntityName” pops up and we are not able to proceed.

I don't know what the issue is and where/how to fix it.

Re: Qlik sense sharepoint

prinzchristian — Wed, 16 Jul 2025 06:56:59 GMT

Good morning everyone,

I’m encountering the same issue in the latest version of Qlik Sense Enterprise on Windows (May 2025 – Patch 3).

Has anyone found a solution or a workaround for this behavior yet?

Thank you very much in advance for your support!

Best regards 🙂

Re: Qlik sense sharepoint

dalshari — Wed, 16 Jul 2025 07:03:10 GMT

Hello Prinzchristian,

hope you are doing well today.

Our issue was solved by enabling access from SharePoint team. We tried to get details what had to be done from their side, but with no luck. Anyway, after enabling com between SharePoint and Qlik, all works as expected.

Regards,

Re: Qlik sense sharepoint

prinzchristian — Wed, 16 Jul 2025 21:04:15 GMT

Hi @dalshari

Thank you very much for your quick reply. I currently suspect that incorrect or insufficient permissions have been assigned in SharePoint. I'll have to check with our IT department again. 🙂