topic Re: persistent SharePoint connection in Data Movement & Streaming

persistent SharePoint connection

gt_nyc — Wed, 19 Mar 2025 22:11:20 GMT

When I create a credential for Sharepoint (in either Personal , Shared or Data spaces), I am able to retrieve files successfully. However we were not able to share this data connection with anyone (even admins).

In other words, if another user tries to use the data connection in a load script, we get the following error message:

Cannot open file 'lib:xxxx' (Connector error: No refresh_token found for Office 365 Sharepoint).

Our expectation is that the token would be saved for the connection not having to generate a token for every single user. Also if it's not the case, how can we schedule a reload if the data connection can only work for a single user?

Re: persistent SharePoint connection

gt_nyc — Wed, 17 Apr 2024 21:31:33 GMT

The reason it was happening is because we had flagged “user defined credentials” .

-> Problem is solved now that we have created a new connection without this flag.

Re: persistent SharePoint connection

faret — Wed, 17 Apr 2024 23:24:36 GMT

No need for sync.. to my view that solution can get messy You can either map a network drive to sharepoint Or add the document library to a network location on file explorer Right click on my computer and you'll see the option If you get stuck let me know I can send you a script I found on "the scripting guy"

Re: persistent SharePoint connection

Ken_T — Wed, 25 Feb 2026 14:06:55 GMT

in my testing, using that setting for sharepoint connection,
"User defined credentials"
does not allow an app to use that connection in a reload schedule, as there is no token and no one logged on to provide it when a scheduled reload task happens. Can anyone else confirm the same?