Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Contributor III
Contributor III

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