Forum Discussion
Invalid credentials SharePoint error (after multiple successful refreshes)
My Power BI report connects to a SharePoint Excel file, which multiple users have access to. For one of those users I used the credentials in desktop and service to set up the scheduled refresh....
Thank you for your answer. Maybe as a bit more context: it is a report developed for a client of mine, not for myself.
The refresh uses a gateway connection, and the login credentials are based on their Microsoft account login.
Maybe this is what forms the issue? Is it possible that the internal IT regulation/security of the client is what's causing the problem?
The credentials are stored in the gateway connection settings, so they should only be returning as invalid if they are actually invalid - the stored password doesn't "disappear" there periodically or anything. Does the account that's used in the connection have password expiration enabled maybe?