Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld online is next week! REGISTER NOW

Fetching data from files on SharePoint with Qlik Sense

cancel
Showing results for 
Search instead for 
Did you mean: 
Zareh_T
Support
Support

Fetching data from files on SharePoint with Qlik Sense

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:

 

 

Tags (1)
Labels (2)
Version history
Last update:
‎2021-02-03 04:58 AM
Updated by: