- Confirm that your OneDrive folder is synced to your local machine by signing in to your browser.
- Log in and open your Qlik Sense app, and click Data load editor from the top menu.
- Click Create new connection in the Data connections panel on the right.
- Select OneDrive from the list of connectors.
- Click Authenticate to open the Microsoft sign-in page. Log in to your account and grant Qlik permission to access your files.
- Copy the authentication code provided by Microsoft and paste it into the Qlik connector dialog, then click Verify.
- 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.
How to Integrate Qlik with OneDrive
Try this interactive demo to learn how to integrate Qlik with OneDrive.
📌 Why this matters
Why this matters
OneDrive is a standard file storage solution in Microsoft 365 environments, making it a common place for business files like reports, trackers, and client data. Because OneDrive syncs automatically to your local machine on Windows, loading those files into Qlik Sense requires no additional setup beyond pointing to the right folder. This makes it one of the most straightforward ways to connect cloud-stored files to your Qlik app. For teams already using Microsoft 365, it removes the need for manual exports and keeps your data pipeline simple and maintainable.
Your product deserves an interactive demo
