Forum Discussion
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...
As far as I know, you could try to use the "From Web" source with the corresponding REST API and write Power Query Formula Language in the Advanced Editor.
Is this the only way to connect to a Sql Server on AWS instance from Power BI ? We are trying to do the same thing as well, is there something different in teh new releases?