Load Data from OneDrive, with error "Operation Aborted"

[ECEK]

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? 

[Ray_Strother]

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/Conne...


2. OneDrive V2

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So...



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-S...

[ECEK]

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 

[ECEK]