Forum Discussion
Can we connect Azure Database from Power BI desktop
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
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
1 Reply
v-huizhn-msftMicrosoft Employee
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