Forum Discussion

avk's avatar
avk
Frequent Visitor
8 years ago
Solved

Can't connect to SQL Server on AWS EC2

Hi All,   We have a SQL Server installed on AWS EC2 instance, we are trying to explore the possibility of having a secure connection from the Power Bi service to SQl Server on AWS. We are not explo...
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Maybe, would depend on your setup in AWS and the firewall rules that are in place. Would have to get the connection string correct for connecting remotely to the SQL Server. Or, you could just use Azure and make your life easy... ;)

avk's avatar
avk
Frequent Visitor
8 years ago

Thank you for your reply , I'm able to connect to the SQL Server  instance on AWS  from Power Bi desktop, I'm using the connection string as ServerIP\SqlServerInstanceName,1433, however to have this connection go through, I have to open the port 1433 on the firewall have public access.

 

I'm trying to explore if Power BI service can connect  to SQL Server on AWS EC2 without having to generate a file from the dekstop first and publish that to the service. Is this possible? Does Power Bi service support connectivity to Sql Servers on other clouds?

 

I wish we could go with Azure and make life but cannot.