Conectar Power Bi Service con servidor de MySQL

[ramon74]

Buen dia, tengo un problema, mi base de datos esta en un servidor de base de datos de la empresa, necesito que mi informe, que esta en la nube de power bi, se conecte al servidor de MySQL para que se actualice, pero me pide que instale el Gateway en el computador donde tengo el power bi desktop, el problema es que si tengo el computador apagado, suspendido o fuera de línea por cualquier razon, el informe de la nube no se actualiza. 

Debe tener alguna forma de conectar el informe que esta en la nube con mi servidor de base de datos MySQL corporativo, alguien puede decirme como ????

[venal · Accepted solution]

@ramon74 

Please refer the link and as the data source (My SQL) is in On-Premesis Server.

Gateway is required to refresh the report. So please install the Gateway in server machines which are always in online.

If you have any queries, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR

venal.

[Anonymous · Accepted solution]

@ramon74 

Unfortunately, you must need a running online gateway if you connected to MySQL database since this is a on-premies. Currently, the only databases supported by the cloud gateway are Azure SQL DB, Azure SQL Data Warehouse, Azure Analysis Services and Spark on Azure HDInsight, basically Azure.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[venal · Accepted solution]

@ramon74 

Please refer the link and as the data source (My SQL) is in On-Premesis Server.

Gateway is required to refresh the report. So please install the Gateway in server machines which are always in online.

If you have any queries, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR

venal.