Knowledge

[Zareh_T]

SharePoint is an online portal that can be used to store and share files.

When trying to create a data connection to SharePoint from Qlik Sense to fetch data from a file, you may experience connection errors due to permission on the Sharepoint  server.

You will need to consider the options below:

Depending on the authentication method applied,  the first option would be to add the Qlik system service account to the site permissions on SharePoint.

Alternatively, data can be fetched for example from an excel file that is placed on SharePoint.

See below for multiple options on how to begin loading in data:

• How to load an Excel file from sharePoint to Qlik 
• Map SharePoint document library as a network drive and then select the file to load in the normal way. ( load from file ) 
  Ref found in Qlik Sense Online Help: Create > Managing data > Connecting to data sources > Loading data from files
  Note: These connection types may only be valid for SharePoint versions 2010 or 2013, and are not supported for 365. APIs are used in SharePoint 365 and best practice is to use Qlik Wed Connectors as mentioned below.
• Qlik Web Connectors using office 365 SharePoint connector (On-premise version only)
  Ref found in Qlik Connectors Online Help: Qlik Web Connectors > Data sources included in Qlik Web Connectors > Office 365 Sharepoint
• Implement Zone to Site Mapping in Internet Explorer 
  See Cannot get QlikView/Qlik Sense to access SharePoint List 
• Webfile connection
  Ref found in Qlik Sense Online Help: Create > Managing data > Connecting to data sources > Loading data from files
• REST connection
  Ref found in Qlik Connectors Help: REST
• 3rd party connectors such as Office 365 Connecto For QlikView And Qlik Sense  ( unsupported )
  Source: Wiki.qvsource.com Office 365 Connecto For QlikView And Qlik Sense
• Use OData.
  Ref found in Qlik Connectors Help: Qlik Web Connectors > Data sources included in Qlik Web Connectors > OData

You can also share QlikSense QVF apps on SharePoint:

• Map SharePoint document library as a network drive and then copy the Qlik Sense QVF files to place them in that folder.
• Use a 3rd part FTP Connector for Sense http://wiki.qvsource.com/File-Transfer-Connector-For-QlikView.ashx ( unsupported )