Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
lavblack
New Member

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? 

1 ACCEPTED SOLUTION
AnkitaaMishra
Super User
Super User

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 :

AnkitaaMishra_0-1765989998569.png

AnkitaaMishra_1-1765990091563.png

 

View solution in original post

3 REPLIES 3
cengizhanarslan
Super User
Super User

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

_________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated
Connect on LinkedIn
AI-assisted tools are used solely for wording support. All conclusions are independently reviewed.
AnkitaaMishra
Super User
Super User

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 :

AnkitaaMishra_0-1765989998569.png

AnkitaaMishra_1-1765990091563.png

 

BeaBF
Super User
Super User

@lavblack Hi! In Power BI Desktop, SQL login credentials are not edited inside the model. They’re stored as data source permissions. You can find them here:

BeaBF_0-1765985442051.png

 

Then click on "Data source settings". Select your connection and then "edit".

 

BBF


💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!

Community News image 1920X1080.png

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.