Forum Discussion
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...
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
not able to find a way to connect from Power BI servcie to Sql Server on AWS instance. The sql server is not a RDS on AWS but on a EC2 instance, I was able to connect to Sql Sever from Power Bi desktop but the main intention is to connect using Power BI, is this possible. Please advise.
- Hi,
Did you find a way to connect to SQL Server on AWS EC2 instance?
How are you refreshing content?
Have you installed the on-premises gateway on the AWS EC2 instance or on a local server machine?Anonymous Did you manage to connect?
What settings do you need to schedule a refresh from AWS?
