Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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....
Need Help
christinepayton's avatar
christinepayton
Most Valuable Professional
3 years ago

It shouldn't, you do need to enter them after you publish though. It sounds like you did that. You could try adding a gateway connection for the source even though it's not required and use a service account credentials though. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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? 

     

    • christinepayton's avatar
      christinepayton
      Most Valuable Professional
      3 years ago

      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?