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]);