topic Re: Import Data from SharePoint into QlikSense in Connectivity & Data Prep

Import Data from SharePoint into QlikSense

Thu, 09 Jun 2016 13:32:31 GMT

Hello Qlikers!

I have a requirement to pull data into QLIK SENSE from a SharePoint list. So far I have attempted the following method:

RPC Calls

Selected WebFile -

Entered the following URL with correct content - http://my-server/my-site/_vti_bin/owssvr.dll?CS=65001;XMLDATA=1;RowLimit=0;List=2D204C18-8C80-468D-AF43-6E81D5EEEE76;View=0F73EC51-F22D-4326-B619-9F383083EF2C

Could you validate this is correct or if this method is only valid for QlikView? Additionally, are there any other methods other than SQL to accomplish this?

Thank you!

Re: Import Data from SharePoint into QlikSense

mgranillo — Thu, 09 Jun 2016 20:09:48 GMT

Tim,

Assuming your link is good, then this should work. You could also use the REST connector. Either method worked for me. The REST connector parses the data a little oddly so I preferred the webfile method.

Mike

Re: Import Data from SharePoint into QlikSense

Fri, 10 Jun 2016 12:39:54 GMT

The URL looks fine. Could it be permissions! The qlik system account has been added to the site permissions on SharePoint.

Is there documentation for the REST method?

Also, I am working on the Qlik Sense Enterprise version. Could this be a reason for the blank screen after XML is selected?

Re: Import Data from SharePoint into QlikSense

Fri, 10 Jun 2016 12:51:47 GMT

Also, I tried on the personal edition desktop and received a error "Access denied. This authentication has failed or has not been provided.

Please kindly advise.

Thank you - TD

Re: Import Data from SharePoint into QlikSense

mgranillo — Fri, 10 Jun 2016 15:17:51 GMT

I've had similar permissions issues with the Enterprise version. I'm still in the process of trying to authenticate our Qlik server to our Sharepoint site.

So far I've only been able to connect to Sharepoint via the desktop version. Are you using the REST connector to pass credentials? My authentication worked fine, but I used the "Use Windows Authentication" = Yes. I really can't help with authentication issues. I've been working through our credential issues with our IT department.

Re: Import Data from SharePoint into QlikSense

Mon, 13 Jun 2016 16:33:17 GMT

I got to to work pain free in Qlik View. No luck found in Qlik Sense.

Re: Import Data from SharePoint into QlikSense

mgranillo — Mon, 13 Jun 2016 20:52:29 GMT

Thanks for passing along the information

Re: Import Data from SharePoint into QlikSense

tschollqlikview — Tue, 30 Jan 2018 11:07:18 GMT

If you do it on Enterprise you running as the service user. Enable the service user on your sharePoint and it will work like a charm

Re: Import Data from SharePoint into QlikSense

jaypadhya — Wed, 07 Feb 2018 19:10:04 GMT

Hi,

try to go to the excel file from the web connector.

Please make sure that the URL looks like :

https://yourwebsitehere/Folder1/SubFolder/YourExcelFile.xlsx

So basically when you enter this URL in your browser, you should be able to download the excel file on desktop.

That way your QlikSense will show that you connected excel via a website.

Re: Import Data from SharePoint into QlikSense

vinitasoni — Wed, 13 Mar 2019 06:22:24 GMT

I am trying to connect an macro enabled file(.xlsm) from sharepoint.

Is it possible as I am getting an error?