How to Integrate Qlik with a SharePoint List

This tutorial shows how to connect Qlik Sense to a SharePoint list and load its data for analysis and visualization.

Notes:

• SharePoint lists can be accessed in Qlik Sense using the REST connector or the SharePoint Online connector available in Qlik Sense Cloud.
• You need the SharePoint site URL and appropriate read permissions on the list.
  

1. Log in and open your Qlik Sense app, and click Data load editor from the top menu.
2. Click Create new connection in the Data connections panel on the right.
3. Select SharePoint Metadata or REST from the connector list, depending on what is available in your environment.
4. Enter your SharePoint Base URL.
5. Click Authenticate to open the Office 365 sign-in page. Log in to your account and grant Qlik permission to access your files.
6. Copy the authentication code provided by Office 365 and paste it into the Qlik connector dialog, then click Verify.
7. Click Create to store the connection. You can now access the saved connection, browse the available tables, and select the ones you want to load into your app.