Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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
Highlighted
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

View solution in original post

4 Replies
Highlighted
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

View solution in original post

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

Highlighted
Specialist
Specialist

Re: Pulling data from XLSX in Sharepoint

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

Highlighted
Specialist III
Specialist III

Re: Pulling data from XLSX in Sharepoint

Then you may have to use Qlikview Service account.