Connection Mysql

[GabrielAlzate]

hello my friends,

the question is: 

We have a database on the web using Mysql, "it is not local", therefore we do not need a gateway. How to connect to this database using Power bi on web, to make the automatic update of the database?

[aj1973]

Hi @GabrielAlzate 

Here is instructions

https://learn.microsoft.com/en-us/power-query/connectors/mysql-database

You don't need a Gateway, so don't add it

[GabrielAlzate]

Hello my friend

My dashboard is connected to database of Mysql (the database is on the web), it work good using Power bi desktop, please see the photo:

but, when I use the power bi app on the web, it ask me a gateway to anable configurate the automatic update.

I need to creat a connection of Mysql using the Powe bi app on the web, to update the dababase automatic

[aj1973]

Looks more like a Local server my friend

therefore you need a Gateway

and this is a Sharepoint Online

and I think you picked the wrong connector or the wrong URL. There are 2 ways to connect to Sharepoint online via Desktop in order to have it well connected in the Service.

This is wrong

You don't add Sharepoint to the Gateway

[GabrielAlzate]

hello my friend

 the dashboard have two connections, one of them is a file excel on sharepoint (it works good, it dont need gateway) and the second conector is to database to Mysql ( it is on the web, goddady)

I need to conecto to my database on the goddady