1 Reply Latest reply: Feb 23, 2018 12:24 AM by Gary How RSS

    Loading excel files from SharePoint using Qlik Sense



      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:



      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?