Qlik Web Connector

[charlie_bailey]

I am attempting to use the Qlik Web Connector to read .XLSX data from on-premise Share Point. Will the Outlook 365 Connector provide this capability? I am guessing it is more designed for accessing Office 365 data in the cloud.  I do not even think the service account I use has an Office 365 account.  Here is the error I am receiving when i attempt to authenticate.

[Nick_Asilo · Accepted solution]

@charlie_bailey please see the following article, Fetching data from files on SharePoint with Qlik Sense, it includes a number of methods for loading data from Sharepoint.

Admittedly some of these options only work for SharePoint 365 but there are options for the on-prem variant, the most reliable option, in my opinion, is to map the SharePoint document library as a network drive and then perform a normal load from file operation.