Loading excel files from SharePoint using Qlik Sense

[#1]

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

[garyhowjtc]

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