Can't connect to Azure Database

[mayankkapoor85]

hi community,

I have the latest version of Power BI installed on my desktop(2.47.4766.801 ) and I am trying to connect to an Azure SQL database.

I have entered all the login information correctly also from the azure management portal the firewall has been changed to accept my IP but still, i am getting an unauthorised user error. pls, see the attached screenshot. Any help will be appreciated.

[v-yuezhe-msft]

@mayankkapoor85,

Are you able to connect to Azure SQL Server from SQL Server Management Studio? Please define a IP range that contains your IP address in firewall rule and wait for 5 minutes, then check if you can connect to the Azure SQL database.

Regards,
Lydia

[mayankkapoor85 · Accepted solution]

got it fixed. gave my system to the developer through remote and he added the path and correct password. 

Thank you for your help

[bcltd]

What do you mean "path and correct password"? We've definitely got the correct password for logging into the two azure databases we've tried (MySQL and MS SQL, tried via plain MS SQL option and via Azure SQL database option from the "Get Data" icon on toolbar), and tried combinations of usernames with the @ in and without, and using tcp:hostname.com as well as just hostname.com for the server name, I think I even tried tcp:x.x.x.x with an IP address that the azure.microsoft.net (or whatever it is) resolves to. Using Direct Query mode all the time, alternative credentials from Windows default, have even tried running PowerBI Desktop as an administrator and made a couple attempts to connect (though my user I login as on Windows, with a password, does have strong permissions).

Connections to the database work fine from the same Windows 10 install that the PBI desktop runs on when using any other method we've tried that should work, from the ms server management studio, or for MySQL from HeidiSQL and from command-line (and even from command line on a Linux VMware vm running on the same host). It won't connect; when trying to talk to the MariaDB (MySQL) on a different (non-Azure) host, that also works from all the other places, which doesn't have SSL enabled, I don't even see tcp packets arriving at the 3306 port and the firewall is not blocking them as any other client works to that one.