Forum Discussion

execman's avatar
execman
New Member
10 years ago

Need help with connecting to a MySQL server

Hi,    I am a new Power BI user and is trying to connect to a MySQL database. I tried many different setting but I am unable to get it to work.    Setup: I added my computer's IP address in Cpane...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

lakshnajha - Here is what I would do, first, download and install MySQL server and tools on the desktop you are using Power BI Desktop on.

 

http://dev.mysql.com/downloads/mysql/

 

Make sure you can connect to your local MySQL server. Then, try to connect to AWS MySQL server. Let me know if that works.

AbdulMukhtar's avatar
AbdulMukhtar
Frequent Visitor
10 years ago

My case is:

  • server is on Azure, MySQL Database. 
  • I need to pull the data into PowerBI service every hour

By following below link on community.power Bi site. I have concluded following approach.

http://community.powerbi.com/t5/Service/connect-mysql-to-web-version-of-Power-Bi/td-p/2668 

    i) Connect to My sql Database using Power BI Desktop 

   ii) Deploy Power BI desktop to power BI service

  iii) Schedule data referesh using Personal gateway.

 

I would like your comment on whether the above approach is correct or not and in case it is correct where do i need to install "Personal gateway" on Azure server (Since database is on cloud) or my personal desktop or any machine?

 

  • dlash's avatar
    dlash
    New Member
    9 years ago

    So does powerBI support connecting to a database server running on a remote machine? 

    It appear the diaload does not even support a mysql port number. 

     

    So does it NOT work?