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