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

Re: Need help with connecting to a MySQL server

Hello,

 

I'm getting the very same error. I try to connect MySQL server running on my laptop with Power BI Desktop edition also on my laptop. Of course I have already installed the 64bit MySQL connector. My OS is Windows 7. my_sql.JPG

Any help is more than welcome.

 

Many thanks

tolisg Frequent Visitor
Frequent Visitor

Re: Need help with connecting to a MySQL server

I found the solution on my own. I used 127.0.0.1:3306 in Power BI as Server declaration instead of "localhost" and it worked!

Alice Occasional Visitor
Occasional Visitor

Re: Need help with connecting to a MySQL server

Hi! I have the same error when i'm trying to connet to the remote server with mySQL database. I've tried different variations of server name, but it doesn't work. Does anybody know how the string with server name should look like? 

Highlighted
dlash Frequent Visitor
Frequent Visitor

Re: Need help with connecting to a MySQL server

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? 

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