OK I have my connection to SharePoint but my understanding is that you have to make a connection down the excel file?
I have other connections that grab multiple excel files at one time, but this does not work for SharePoint?
FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]
(ooxml, embedded labels)
FROM [lib://Aperion Bloomington SharePoint (pharmore_rwinkel)]
(ooxml, embedded labels, header is 4 lines, table is [Aperion Care of Bloomington]);
try to go to the excel file from the web connector.
Please make sure that the URL looks like :
So basically when you enter this URL in your browser, you should be able to download the excel file on desktop.
That way your QlikSense will show that you connected excel via a website.