Can we connect Azure Database from Power BI desktop

[vipin_jha123]

Hi , 

I am trying to connect my Azure SQL database from the Power BI Desktop , I am not able to connect  it and getting below error

even I have configured firewall setting.

Please help me with correct way of connecting

Error

[v-huizhn-msft · Accepted solution]

Hi @vipin_jha123,

In your scenario, do you install SSMS on the same machine that has Power BI Desktop installed? If you install it, can you connect Azure Datebase in SSMS? If you still haven't connect using SSMS, which means you didn't configure your Azure database well. 

 Azure should be configured to allow your client to connect via the firewall, and remotely. For more details about configureing Azure database, please post the question to right forum.

Please make sure you configure it well, then double check you have the correct credentials, type the right server, databse and credentials. And check if it works fine. You find the server and database name in Azure portal as follows, please review this article.  



Best Regards,
Angelia