How to Integrate Qlik with SharePoint

This tutorial shows how to access files stored in SharePoint and load them into Qlik Sense for analysis.

Notes:

• Qlik Sense Cloud has a native SharePoint Online connector available under Data Connections. Qlik Sense Desktop users can sync SharePoint libraries using the OneDrive sync client and load files as local files.
• SharePoint lists require a different approach. See the dedicated tutorial on integrating Qlik with SharePoint lists.
  

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 Office 365 SharePoint from the connector list if you are on Qlik Sense Cloud, or browse to your locally synced SharePoint folder if you are on Desktop.
4. Enter your SharePoint Base URL and Site/Subsite path.
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.