topic Load Data from OneDrive, with error "Operation Aborted" in Data Movement & Streaming

Load Data from OneDrive, with error "Operation Aborted"

ECEK — Wed, 19 Mar 2025 22:43:16 GMT

Hello,

I am trying to load data from OneDrive to Qlik.

When I "Insert Script" and progress to "Load Data", I receive the error "Operation Aborted"; sometimes it takes 2 minutes, and sometimes it takes more time to fail with the error mentioned above.

To debug this issue, I've tried to load an Excel I uploaded on OneDrive with Column names only without the data to succeed in the operation, but when adding data to the Excel, the operation is aborted after a couple of minutes in the data load editor...

what should I look for to fix this problem?

Re: Load Data from OneDrive, with error "Operation Aborted"

Ray_Strother — Fri, 08 Dec 2023 18:14:26 GMT

Hello,

Please review the links below and ensure the correct options and configuration are done.

Article links:
1. OneDrive

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/OneDrive-storage-provider-connector.htm

2. OneDrive V2

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-Source-Connectors/OneDrive-V2-Connector.htm

3. Loading shared One Drive Excel data into Qlik Sense

https://community.qlik.com/t5/Connectivity-Data-Prep/Loading-shared-One-Drive-Excel-data-into-Qlik-Sense/td-p/2072781

Re: Load Data from OneDrive, with error "Operation Aborted"

ECEK — Wed, 13 Dec 2023 08:39:28 GMT

Hello, Ray_Strother,

Thank you for the reply,

Well, the connection between Qlik and One drive is working fine, the Excel file is connected and I can choose it from the Onedrive personal storage..
the thing is: my Excel file has 7 sheets when trying to load all of them I receive an error the error is in the pic below, and the qlik page that I opened in the browser disconnected and reloaded again, but when loading one of the 7 sheets I don't face any problem...

is there any option that need to be modified maybe to give me more time to load data in the connection between onedrive and qlik?

thank you

Re: Load Data from OneDrive, with error "Operation Aborted"

ECEK — Wed, 13 Dec 2023 08:40:48 GMT