Forum Discussion

lavblack's avatar
lavblack
New Member
8 months ago
Solved

how to edit login

I am gettingthe following message "Microsoft SQL: Cannot open server "uhhospitals.org" requested by the login. The login failed.".  How do I find the place to edit the login information? 
Need Help
  • AnkitaaMishra's avatar
    AnkitaaMishra
    8 months ago

    Hi BeaBF , you can edit the credentials by going to file ---> Options and Settings---> select the correct database and click on edit permission ---> click edit as shown in the below image :

     

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
8 months ago

If this happens in Power BI Service:

  1. Go to Workspace

  2. Open Semantic model (Dataset) → Settings

  3. Under Data source credentials, click Edit credentials

  4. Re-enter the correct:

    • Authentication method (SQL / Windows / Azure AD)

    • Username & password

  5. If applicable, verify the Gateway mapping is correct

If this happens in Power BI Desktop:

  1. Go to File → Options and settings → Data source settings

  2. Select the SQL source → Edit Permissions

  3. Update or clear credentials and reconnect

  4. Refresh the model