Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
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
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |