0 Replies Latest reply: Jul 27, 2016 1:32 PM by Alan Hendrickx RSS

    Loading excel files from SharePoint using Qlik Sense

    Alan Hendrickx

      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