Forum Discussion

Chintan982's avatar
Chintan982
Regular Visitor
9 years ago

Power BI connecting to AWS EC2 instance with MS SQL

Hi   I have MS SQL instance on AWS EC2. Can anyone help me know how can I have power BI connect to that SQL instance to get data. Its not AWS Redshift and we do not intend to invest in Redshift at...
Need Help
LSweenie's avatar
LSweenie
Frequent Visitor
9 years ago

Hi,

 

We are doing similar but connecting to MySQL on AWS.  We are using ODBC connections to MySQL on AWS from desktop and also have an Enterprise Gateway set up with the ODBC connections so we can schedule refreshes.  Works well apart from some issues with publishing reports with ODBC datasources which we're currently working around while MS investigate.

 

Hope this helps,

Linda