Discussion board where members can get started with Qlik Sense.
I want to load xls file directly from the sharepoint.
I tried to create new web file connection and put the path of SP in the URL - but the QS didn't recognize the xls file.
Do you have any idea how to load the file?
Go to Solution.
Can you try this, We have to turn our URL into a path.
Original URL = http://wssemea.sample.com/ws/MTPlanManagement/QlikView Folders/GLOP/*.xls'
Path used = \\wssemea.sample.com\ws\MTPlanManagement\QlikView Folders\GLOP\*.xls'
If you launch the file from Sharepoint into Excel and examine the connection string information - you will see how it is connecting to its source data.
Here is a blog post I did some time ago (prior to joining Qlik) that may be useful.
Getting SharePoint data into QlikView | Walter Shpuntoff on QlikSense and QlikView
Note: even though that was written for QlikView, it will work equally well with Sense.