How to Connect SharePoint 2013 Document Library On Prem in QlikSense

[shahzad]

Dear I would like to Connect SharePoint 2013 Document Library On Prem with Qlik Sense. I have web link with path.

Sample Link: https://hostname.domain.com/Foldername/Foldername/Foldername

When I open this link using browser or File Explorer, it gives me the list of excel files. I want to read these excel files on QlikSense.

I have tried folder data connection. But when I put the link files doesn't appear. Even read access is granted to Service Account as well.

I have tried web file connector. That's also not working.

I have tried Qlik Office 365 Sharepoint Connector that's also not working.

Does any one have other solution. Is there something missing from my side while connecting.

Thank you

Regards

Shahzad 

 

[Vicky_Z]

the screenshot is folder connection. I believe you should use SharePoint connector in Web connector package which needs some setup.  The built-in one is Office 365 SharePoint Metadata connector. 

You may follow this video and see if that works for you:

How to load a file from SharePoint 365 using Qlik Using Qlik Web Connectors 

https://community.qlik.com/t5/Official-Support-Articles/How-to-load-a-file-from-SharePoint-365-using...

If it does not work, which step and what error exactly? 

[Rakesh_HB · Accepted solution]

Hello @shahzad ,

Unfortunately, SharePoint 2013 is not supported.

Also, SharePoint Server 2013 Service Pack 1 and SharePoint Foundation 2013 Service Pack 1 will remain the minimum supported build through the end of mainstream support on 4/10/2018.

Updated Product Servicing Policy for SharePoint 2013 

You may check the old configuration but there will be no support from Qlik:

How to Connect QlikSense to a 2013 SharePoint List

Instead, you can use SharePoint Office 365

There are multiple ways to connect to SharePoint Office 365;

1. Using built-in Qlik Web Storage Provider Connectors
2. Using Qlik Web Connectors

For more information, please check the below:

• Fetching data from files on SharePoint with Qlik Sense  
• How to load lists using SharePoint 365 [Qlik Web Connectors On-premise] 

Please remember to hit the 'Like' button and make helpful answers as 'Solution Accepted'... Cheers!