Connection to SharePoint from QlikSense - Help

[Anonymous]

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!

EP

[robert_mika]

Did you check this post:

(Sharepoint) integration with Qlik Sense

[Anonymous]

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

[#4]

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]

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.