Forum Discussion

Evelien's avatar
Evelien
Advocate I
4 years ago
Solved

Cannot connect to database after 1 failed login attempt

Hi, I tried to connect to an SQL server database and had chosen the wrong login.  I would like to reconnect with the correct login, but whenever I enter the server and database, I am immediately dir...
  • BA_Pete's avatar
    4 years ago

    Hi Evelien ,

     

    It should still be in your Global Permissions list.

     

    Go to Data Source Settings in Power Query. At the top of the dialog, you should see two radio buttons: 'Data sources in current file', and 'Global permissions'. Select this second one, find your source, then either clear the permissions entirely and re-do them, or edit them with the correct credentials.

     

    Pete