Forum Discussion

WSD's avatar
WSD
Frequent Visitor
2 years ago
Solved

Sharepoint connection credential expiring

For one of the reports I am working on, part of the datasource is a connection to a sharepoint folder.  Now I am using my personal company account to provide credentials for the sharepoint.  ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, WSD 

    Frequent expiration of credentials can be due to OAuth2 token settings. By default, access tokens have a limited lifetime for security reasons. Like Bendlin said, you can ask your IT department to extend the token lifetime or implement a refresh token to automatically renew the access token without manual intervention. You can refer to the following link:

    How to extend the expiry of access token so I don't have to refresh as often - Microsoft Q&A


    This issue can also stem from a server-side security policy set by your organization. These policies may need to be reauthenticated periodically to ensure secure access to sensitive data. Consulting with your IT or SharePoint administrator can provide insight into whether these policies can be adjusted. Here is the link:

    Manage guest expiration for a site - Microsoft Support


    If you have access to someone who can run PowerShell scripts, they may be able to change the IPAddressWACTokenLifetime parameter to extend the lifetime of the token.

    Your session has expired in Office Online - Microsoft 365 | Microsoft Learn


    Another approach is to use app-only credentials for SharePoint access. This method involves setting up an app with the necessary permissions in Azure AD and authenticating with its credentials. This can provide a more stable and long-lasting connection. You can check the following link:

    proconnector.hingepoint.com


    Make sure that the scheduled refresh settings for the report are optimized. Sometimes, adjusting the refresh rate or timing can help reduce the need for frequent re-authentication.

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.