Forum Discussion
Can't connect to SQL Server on AWS EC2
avk,
It is not possible to directly connect to SQL Server in Power BI Service, you can firstly connect to SQL Server in Power BI Desktop. create reports in Power BI Desktop, then publish the reports to Power BI Service following the guide in the article below.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-upload-desktop-files/
Regards,
Lydia
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.
avk,
It is not possible to directly connect to SQL Server in Power BI Service, you can firstly connect to SQL Server in Power BI Desktop. create reports in Power BI Desktop, then publish the reports to Power BI Service following the guide in the article below.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-upload-desktop-files/
Regards,
Lydia