cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
execman Frequent Visitor
Frequent Visitor

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 Cpanel via the Remote MySQL panel. 

 

Server: I tried using the IP address of the server, my website's url, with and without "www"

Database: I entered the database name

 

Credentials: 

Windows: Not Selected

Database: Selected

 

Username:

Password: 

 

For the username and password, I tried the MySQL database password and the cpanel password. 

 

Please assist if you can. Thanks in advance. 

 

13 REPLIES 13
Super User IV
Super User IV

Re: Need help with connecting to a MySQL server

Are you trying to connect from the service or from Power BI Desktop or from Excel?

 

I have an article on TechNet that gives some notes around this:

http://social.technet.microsoft.com/wiki/contents/articles/32004.power-bi-tips-for-working-with-mysq...

 

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

execman Frequent Visitor
Frequent Visitor

Re: Need help with connecting to a MySQL server

I am trying to connect it via Power BI Desktop directly. So it would be from Get Data - More - Database - MySQL Database. 

lakshnajha Frequent Visitor
Frequent Visitor

Re: Need help with connecting to a MySQL server

Hi

I am getting error. I downloaded the version from microsoft link 

http://dev.mysql.com/downloads/file/?id=412152

but still getting it

Pls help

We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.
This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'MySQL Connector/Net': https://go.microsoft.com/fwlink/?LinkId=278885"

 

tx

Super User IV
Super User IV

Re: Need help with connecting to a MySQL server

Generally when I have gotten this to work, I have had MySQL installed directly on the boxt that I am using Desktop on. Can you provide any details about your configuration?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
lakshnajha Frequent Visitor
Frequent Visitor

Re: Need help with connecting to a MySQL server

Hi

 

Thanks for your response.

I have a deskptop power BI and using AWS database to connect to.Please let me know what other info you need from me.

Super User IV
Super User IV

Re: Need help with connecting to a MySQL server

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


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

lakshnajha Frequent Visitor
Frequent Visitor

Re: Need help with connecting to a MySQL server

hi 

is it possible to use power BI on mac machine. My primary machine is mac so i will love to use power BI on that

lakshnajha Frequent Visitor
Frequent Visitor

Re: Need help with connecting to a MySQL server

on my windows machine works. thanks so much

AbdulMukhtar Frequent Visitor
Frequent Visitor

Re: Need help with connecting to a MySQL server

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?

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors