Forum Discussion

GabrielAlzate's avatar
GabrielAlzate
New Member
2 years ago

Connection Mysql

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

4 Replies

    • GabrielAlzate's avatar
      GabrielAlzate
      New Member
      2 years ago

      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's avatar
        aj1973
        Community Champion
        2 years ago

        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