Qlik Community

Connectivity & Data Prep

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
elena888
Specialist
Specialist

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

4 Replies
robert_mika
Master III
Master III

elena888
Specialist
Specialist
Author

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

Not applicable

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

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.