cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ramon74
New Member

Conectar Power Bi Service con servidor de MySQL

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 ????

2 ACCEPTED SOLUTIONS
venal
Memorable Member
Memorable Member

@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.

View solution in original post

V-pazhen-msft
Community Support
Community Support

@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.

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@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.

View solution in original post

venal
Memorable Member
Memorable Member

@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.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!