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

[jertel]

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.

[v-yuezhe-msft]

@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

[jertel]

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.

[v-yuezhe-msft]

@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

[jertel]

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.