Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Importing data stored in Sharepoint

Is it possible to setup Qlikview to import data that is within an Excel Sheet stored in Sharepoint? I am not looking for a difficult solution. Rather, I am trying to find out if this is easily done like it is with other common data sources.

Thanks!

17 Replies
rajni_batra
Specialist
Specialist

hello Steve ,

thanks for ur reply but i ma really confused can u please explain me that what exactly we need to fetch data from share point.

is there any QV source or any other set up is required for it...

what exactly it is????

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Rajni,  The solution I put in was on a client site, and I'm afraid I don't have access to a SharePoint server to revist this at this time.  I seem to recall that when the SharePoint server was configured in the right way QlikView could see the spreadsheet exactly as if it was on a regular network share.  If the correct permissions were granted then no pop-up would appear asking for credentials.  From when I was reading up at the time I recall the version of SharePoint made a difference, as did the platform (64 or 32 bit) it was installed on.

Sorry I can't be of more help at this time.  I'm sure someone else will be able to offer a solution though.

- Steve

fosuzuki
Partner - Specialist III
Partner - Specialist III

Rajni,

The problem is that it is not possible to config QlikView to pass the user/pwd to authenticate in Sharepoint. QlikView will use the credentials of the user doing the reload.

You should config the Sharepoint site allowing your user (the user you are logged on your machine in case you're reloading from QV Desktop OR the user configured in the QlikView Server's services if you're reloading through a task in QV Server) to access the XLS file without inputting user/pwd.

(I think that this is what Steve suggested, but in other words... )

Hope this helps you

Fernando

qlikviewforum
Creator II
Creator II

Hi All

The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.

Created the new thread for the same below.

http://community.qlik.com/message/249859#249859

Thanks,

qlikview forum

qlikviewforum
Creator II
Creator II

Hi All,

I tried my level best but unfortunately couldn't able to succeed yet.

I read some where about QVSource. Is it possible to load the data from secured sharepoint site using the same? Any help please?

Thanks,

qlikviewforum

chrisbrain
Partner - Specialist II
Partner - Specialist II

You should be able to load data from Sharepoint 2010 if it's on the same network (as opposed to an internet hosted instance).

We have some notes here:

http://www.qvsource.com/wiki/Sharepoint-Connector-For-QlikView.ashx

Did you try it already?

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
qlikviewforum
Creator II
Creator II

Hi Chris

Thanks for your reply! The link which you have attached is no more working.

Thanks,

qlikviewforum

Anonymous
Not applicable
Author

The link is now:  Sharepoint Connector For QlikView - QVSource: The QlikView & Qlik Sense API Connector (Docs)

However, it does not have anything to do with Excel files.  It is related to Sharepoint lists.