Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Loading excel files from SharePoint using Qlik Sense

Hi,

I am trying to move a script from QlikView to Qlik Sense which loads an excel file from SharePoint. The script does not run and gives an "Invalid Path" error when I try to load using this format:

     "https://sharepoint/site/subsite"

When I change to a UNC path (e.g. \\sharepoint\site\subsite), I get the following error:

     LOAD statement only works with lib:// paths in this script mode

I have more experience with QlikView, so perhaps there is an easy way to resolve this.

Can anyone share a working solution?

Is there a way that I can set up my data sources to load in the same way as Qlikview?

Thanks,

A

1 Reply
garyhowjtc
New Contributor III

Re: Loading excel files from SharePoint using Qlik Sense

‌aanyone managed to do the same above on both qliksense desktop and QlikSense enterprise?