Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
smysore
Contributor
Contributor

Unable to connect to on-premise SharePoint excel files from Qlik sense

Hi Team,

I am trying to connect to our on-premise SharePoint sites to read data into Qlik sense. I have been using the below link as reference

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest

The file which I want to read is a .xlsx file and as a REST connector cannot read excel files, I have tried to use web file connection in the following manner

https://username:password@domain.com/sites/xxx/_api/web/GetFolderByServerRelativeUrl('FolderName')/F...

The above URL is working in any browser with the file being downloaded. But when I give this URL in the qlik web file connection, I am getting Unauthorized error even after providing credentials in the URL.

 

Can someone please help me to resolve this issue? 

Note: Office 365 SharePoint connector is not working for us as ours is an on-premise SharePoint

3 Replies
Vikram_Jayakumar

Hi @smysore 

Could be a known issue depending on the version of Software you are using. Refer to this and if applicable use the workaround and test

If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
smysore
Contributor
Contributor
Author

I have done as per the link which you sent and I am still facing the same issue. 

Vikram_Jayakumar

If you are on a version later the fix and workaround not helping. Open a ticket with support 

If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.