power bi desktop connection

[ilyassdahir]

I try to connect power bi desktop to sql server on azure virtual machine but it doesn't work, how can i enable this connection?

[amitchandak]

@ilyassdahir , First of all, check if are you able to access SQL server on that machine, using SQL server management studio.

It may be IP whitelisting issue

refer

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall...

https://itproguru.com/expert/2011/06/how-to-open-firewall-port-1433-for-sql-server-database-engine-f...

https://www.youtube.com/watch?v=9MMhNu1Pz4A

[ilyassdahir]

yes i can acces to my sql server on azure VM using my SSMS, but when i try to connect the sql server on azure VM to power bi desktop i get an error!!