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: 
cbaqir
Specialist II
Specialist II

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
tseebach
Luminary Alumni
Luminary Alumni

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

View solution in original post

4 Replies
tseebach
Luminary Alumni
Luminary Alumni

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
Specialist III
Specialist III

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

cbaqir
Specialist II
Specialist II
Author

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

nagaiank
Specialist III
Specialist III

Then you may have to use Qlikview Service account.