Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
cbaqirdhds
Valued Contributor

Pulling data from XLSX in Sharepoint

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

1 Solution

Accepted Solutions
Luminary
Luminary

Re: Pulling data from XLSX in Sharepoint

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

4 Replies
Luminary
Luminary

Re: Pulling data from XLSX in Sharepoint

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

nagaiank
Valued Contributor III

Re: Pulling data from XLSX in Sharepoint

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

cbaqirdhds
Valued Contributor

Re: Pulling data from XLSX in Sharepoint

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

nagaiank
Valued Contributor III

Re: Pulling data from XLSX in Sharepoint

Then you may have to use Qlikview Service account.