Qlik Community

Qlik Sense Data Connectivity

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

elena888
Valued Contributor

Connection to SharePoint from QlikSense - Help

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

Tags (1)
4 Replies

Re: Connection to SharePoint from QlikSense - Help

elena888
Valued Contributor

Re: Connection to SharePoint from QlikSense - Help

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

Not applicable

Re: Connection to SharePoint from QlikSense - Help

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
New Contributor II

Re: Connection to SharePoint from QlikSense - Help

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.

Community Browser