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.
Note: even though that was written for QlikView, it will work equally well with Sense.