Connect PowerBI to Azure SQL using different Azure AD authentication

[markcabantog]

I can connect to Azure SQL using  AD authentication (sqluser_ad) in SQL Server Management Studion, but for Power Bi I login using my AD Account (Mark Cabantog) to publish with my resources, when connecting to Azure SQL I cannot use different AD account only "sign in" is there

My AD account (mark Cabantog) does not have access to the Azure SQL only specific AD user (sqluser_ad) , what is the solution for this?

[markcabantog]

when selecting "Database" option i got this error

in Management studio i'm selecting "Active Directory-Password" as Authentication Method and it's connecting fine. The public IP is already in whitelisted.

[PC2790]

Hey @markcabantog ,

Try going to the Database option and login with the same credentials.

If you are able to login in management studio then you should be able to do it using power bi as well.

One more thing you can check that the IP address from the machine you are trying to access is whitelisted to go through

[markcabantog]

when selecting "Database" option i got this error

in Management studio i'm selecting "Active Directory-Password" as Authentication Method and it's connecting fine. The public IP is already in whitelisted.