Hosting import query gateway on a service instead of a personal computer, is it possible?

[Anonymous]

Hi,

We need to connect to Amazon RDS MySQL intances. https://docs.microsoft.com/nl-nl/power-bi/power-bi-data-sources According to this schema we cannot use direct/live query for this. Which leaves us with Import query.

We do not want to have to host a gateway on a personal computer 24/7 for the datarefresh we plan to do every 30 minutes. Is it possible to install the gateway on some kind of service that runs 24/7? (e.g. amazon instances or azure)

Kind regards

[Jayendran · Accepted solution]

Hi @Anonymous ,

You are right you need to install the gateway in a server, But currently the gateway can be installed only in a Windows Server. 

Using windows Server you are good to go.

Make sure that windows server ports for as per this instruction