Forum Discussion
Power BI and SQL Server in the AWS
Hopefully simple questions if someone has used Power BI with SQL Server in AWS... Amazon RDS offers SQL Server in AWS. Connections to the SQL Server instance use a server name along the lines of...
I have tested this and recording the answers for the benefit of others:
Power BI Desktop was able to load from a SQL Server in the cloud (as expected, that's the simple bit).
Power BI Online was NOT able to refresh without using a Gateway. It is currently unable to differentiate it seems between an on-prem and cloud database (with the exception of Azure SQL Database, etc).
I had to set up an a data source in an instance of the Enterprise Gateway pointing at the AWS SQL instance. A shame.
Further, since our firewall blocks outbound connections on 1433, that instance of the Gateway had to be running in a VM in the cloud.