Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |