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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jertel
New Member

Can't get Power BI to accept windows login for sql credentials

I am trying to get Power BI to use windows logins to access our sql server connection rather than a direct sql login.  Direct sql login woks fine through the gateway.  Windows login does not.  We have a local domain at our office that our users log in under and our servers are on amazon cloud on a separate domain.  How to get amazon sql cloud domain to allow windows login credentials from an 'untrusted' domain (this is the error in power BI trace.  login is from an untrusted domain and therefore fails.  Network admin says the only way to create a true trust between those 2 domains would be to rebuild the 2 domain controllers which he obviously doesn't want to do.

4 REPLIES 4
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@jertel,

Are you able to connect to SQL Server using Windows login via SQL Server Management Studio in the gateway machine? If you still get same error, I am afraid that you should establish a trusted relatsionship between the two domains, which is necessary for Windows login.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

No if she tried to connect via ssms on her windows it would be the domain her local box is on which isn't the domain the sql box is on.  Power BI has the credentials to use that are valid on the sql box but it doesn't appear to be trying to log in it just instantly fails without a delay. Is there no way for windows login to work without the cloud domain trusting the local domain?

 

That is what I thought the issue was but I am just hoping there's some way around it as the network admin says the only way to create the trust is to basically redo the domain controllers.

@jertel

Yes. This is a Windows authentication issue in SQL Server. You would need to create trust relation between two domains to make Windows login work.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jertel
New Member

I am trying to get Power BI to use windows logins to access our sql server connection rather than a direct sql login.  Direct sql login woks fine through the gateway.  Windows login does not.  We have a local domain at our office that our users log in under and our servers are on amazon cloud on a separate domain.  How to get amazon sql cloud domain to allow windows login credentials from an 'untrusted' domain (this is the error in power BI trace.  login is from an untrusted domain and therefore fails.  Network admin says the only way to create a true trust between those 2 domains would be to rebuild the 2 domain controllers which he obviously doesn't want to do.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.