topic Re: OneDrive Data Connection Stopped Working in Data Movement & Streaming

OneDrive Data Connection Stopped Working

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

Nothing has changed with the connection. I can no longer Load Data as I get an error that mentions unauthenticated:

However, I am authenticated as you can see:

Any idea what happened?

Thanks!

Re: OneDrive Data Connection Stopped Working

marcus_sommer — Thu, 30 Nov 2023 12:06:24 GMT

Maybe it's rather caused by a kind of missing authorization or in other words you may need to re-new your login directly in onedrive or any kind of certificate or token which is needed to establish a successful connection respectively to the data-access behind it.

Re: OneDrive Data Connection Stopped Working

biddynamics — Thu, 30 Nov 2023 16:52:20 GMT

Thank you for your response. I reset the OneDrive password but still getting the same error. There was no certificate or token created originally and I do not see anywhere to create one. From Load Editor, I’m able to browse all of the files/folders in the OneDrive account but when I try to select one I get the error. One would think that if I didn’t have access I wouldn’t be able to see any of the files or folders in the account.

Re: OneDrive Data Connection Stopped Working

Albert_Candelario — Thu, 30 Nov 2023 21:02:49 GMT

Hello @biddynamics,

Is happening within all the files from OneDrive or for some specific ones, only to you or more users?

Does a reload from the Data Load editor works?

Cheers,

Albert

Re: OneDrive Data Connection Stopped Working

biddynamics — Thu, 30 Nov 2023 21:30:26 GMT

Happens to all files and I am the only user. Reload fails every time with the same message as the above screenshot.

I moved to google drive with no issues there. It makes no sense as to why OneDrive doesn't work anymore.

Re: OneDrive Data Connection Stopped Working

marcus_sommer — Fri, 01 Dec 2023 06:57:21 GMT

That you could see the folders and files and navigate in them doesn't mean that you have also the rights to open and/or write and change them. Quite often are all rights together approved or denied but they could be set differently.

Your issue might be caused by adjusting the rights to a prior folder which are then inherited to all files and sub-folder or the membership of your user in various user-groups was changed or something similar.

Beside this there might be also a conflict of trust between different zones. I don't know if and how this might be implemented in onedrive and/or a belonging sharepoint and other company/network-parts and Qlik but in Power BI there is such logic active by default.

Re: OneDrive Data Connection Stopped Working

Albert_Candelario — Fri, 01 Dec 2023 10:18:48 GMT

Hello @biddynamics,

We would like to have more information about your case:

what device are you using (e.g. is it a mobile device / tablet / desktop)?
are you using a guest or personal account? E.g. guest to an Azure AD administered tenant or 'hotmail' / personal OneDrive
can you get any reload to work (e.g. even a very simple single table load such as list drives/items)

Thanks in advance!

Cheers,

Albert

Re: OneDrive Data Connection Stopped Working

biddynamics — Fri, 01 Dec 2023 13:57:08 GMT

I am using a desktop. Forgot to mention this is Qlik Saas/Cloud. I'm simply trying to use the built in OneDrive connector to connect to a personal OneDrive account. I do not believe you can set permissions in the personal OD account. You can share files/folders. I assumed the authentication in Load Editor granted the permissions. The load fails every time.

Thanks!

Re: OneDrive Data Connection Stopped Working

Albert_Candelario — Mon, 04 Dec 2023 10:05:10 GMT

Hello @biddynamics,

Would it be possible to test a different account or yours an see if you see the same issue. We have tested multiple account of different type and we could not reproduce, so we suspect might be link to your account. It would be great if you could perform such a test.

Cheers,

Albert

Re: OneDrive Data Connection Stopped Working

AlbinAntony — Thu, 21 Mar 2024 04:11:01 GMT

Have you found the issue ?

I'm getting this error only to new files which I have added.