topic Re: Connection to SharePoint from QlikSense - Help in Connectivity & Data Prep

Connection to SharePoint from QlikSense - Help

Anonymous — Fri, 16 Sep 2016 09:22:07 GMT

Hi,

I would like to get data from share point 2013 with qliksense 2.1.4.

I read the community documentation and I tried to use RPC calls but It didn't work.

I got the correct URL and made connection, but when I tried to laod data I got the error: "File format not supported".

I tried also wiht REST Connector but I got the error: 403 Forbidden (I didn't use windows authentication and I used my credential).

Any ideas?

Thanks!

robert_mika — Fri, 16 Sep 2016 09:30:53 GMT

Did you check this post:

Anonymous — Mon, 19 Sep 2016 09:08:26 GMT

Thank you, but I don't want to integrate Sense into Sharepoint, but I need to read data from Sharepoint.

Tue, 07 Mar 2017 16:22:01 GMT

OK I have my connection to SharePoint but my understanding is that you have to make a connection down the excel file?

I have other connections that grab multiple excel files at one time, but this does not work for SharePoint?

Other connection:

FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]

(ooxml, embedded labels)

SharePoint:

FROM [lib://Aperion Bloomington SharePoint (pharmore_rwinkel)]

(ooxml, embedded labels, header is 4 lines, table is [Aperion Care of Bloomington]);

jaypadhya — Wed, 07 Feb 2018 19:08:59 GMT

Hi,

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

Please make sure that the URL looks like :

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.