topic Re: Pulling data from XLSX in Sharepoint in QlikView

Pulling data from XLSX in Sharepoint

cbaqir — Wed, 30 Sep 2015 18:00:10 GMT

I am currently using a .xlsx file that is posted on a protected SharePoint site for my source data. How do I determine what user name needs to be added to the SharePoint Permissions list to successfully access this file?

Thanks,

Cassandra

Re: Pulling data from XLSX in Sharepoint

tseebach — Wed, 30 Sep 2015 19:48:13 GMT

I guess you're using a Qlik Server and you want a task on the server to automatically fetch the file?

If that is the case, the Qlik services are usually run as a domain user, the Qlik server would authenticate itself as this user to the sharepoint server.

To find what users the services run as, click start and type: services.msc on the Qlik server and in the following list look for the services starting with Qlik... look at user colunm for the user.

The alternative method you can use, is to embed the credentials in the URL you're calling to get the file: https://user:password@sharepointserver/path/to/xlsxfile

Re: Pulling data from XLSX in Sharepoint

nagaiank — Wed, 30 Sep 2015 20:19:58 GMT

If you are accessing the file from Qlikview in your machine, you should add your user name to SharePoint permissions.

Re: Pulling data from XLSX in Sharepoint

cbaqir — Wed, 30 Sep 2015 20:26:19 GMT

I am in development but not when the QVW is put into production.

Re: Pulling data from XLSX in Sharepoint

nagaiank — Wed, 30 Sep 2015 20:29:04 GMT

Then you may have to use Qlikview Service account.