topic Qlik SaaS - SharePoint connector issue in Connectivity & Data Prep

Qlik SaaS - SharePoint connector issue

Apoorva_sd — Tue, 25 Mar 2025 22:27:41 GMT

Hello,

I am trying to connect Qlik cloud to SharePoint site and fetch data from one of the excel files in the site. I was able to successfully establish the connection however when I click on "select data" in the connection I am getting the following error message. Has anyone come across this issue?

P.S.: I do have access to the SharePoint site and the file I am trying to fetch data from.

Any help on this is greatly appreciated!

Thank you,

Apoorva

Re: Qlik SaaS - SharePoint connector issue

Chanty4u — Wed, 26 Mar 2025 17:41:46 GMT

May be Verify SharePoint Site URL Format

https://yourcompany.sharepoint.com/sites/yoursitename

Check Permission Level in SharePoint

Even if you can access the site manually, Qlik Cloud might require specific permissions:

You must have at least Read + Download

Check Excel File Name and Path

Enable Legacy Authentication in SharePoint

Re: Qlik SaaS - SharePoint connector issue

Apoorva_sd — Wed, 02 Apr 2025 19:45:55 GMT

Thank you for your response!

Issue has been resolved. It was something to do with the persmissions! After giving the user "Edit" access under "Site Permissions" in SharePoint I was able to access the folder to select the file from.

Thank you.