How to connect to mysql database from power Bi

Question

How to connect to mysql database from power Bi?

Cherukuri · Answer 1 · Mar 22, 2019

Hi,
Follow these steps, to connect to MYSQL database.
1. Click on Get Data.
2. Go to Database and select MYSQL.
3. Download Mysql connector "mysql-connector-net-8.0.15" and install the same.
4. Then Type your server name.
5. Type any Sql statements. (optional)
6. Select mode of authentication (window /database).
7. Select required tables and fields residing in Mysql database for creating your report and visualization.
8. Click Ok.
9. Now the data is retrieved and is ready to create visualizations.

Hope this helps you.

If you are interested in learning Power BI then check out Power BI Course Content now!

answered Mar 22, 2019 by Cherukuri
• 33,030 points

the mysql-connector-net-8.0.15 install at server or at power bi client ?

commented Nov 4, 2019 by RING

I think in Power BI Desktop (on the client machine)

commented Nov 4, 2019 by anonymous
• 6,260 points

So, as is usually the case with online 'advice' the exceptions are the real area of interest. People do not go looking for help if the thing just works ...

After your step 2 there was NO prompt to download the connector. I already have many MySQL odbc connectors installed. Excel understands how to do this correctly. You offer a Queries and Connections option and then adjust the properties.

But a user is paralyzed if they do everything right and the application offers them no chance to change things. All I get after choosing MySQL and hitting the Connect button is this uninformative and unautomated display:

Um, ok, thanks. Like where do I do this? The ODBC stuff is well installed. This is not helpful.

commented Dec 18, 2019 by series0

What do you get when you click on learn more? I am sure you'll get a little more details about what additional components are required.

commented Dec 18, 2019 by pri

So, as mentioned, the ODBC stuff is well installed already. The 'learn more' link only takes me to the Oracle MySQL connector download, which I have already done. Just to be sure of course I uninstalled it, and reinstalled it. And then I I rebooted my computer (ha ha). Nope, that is not it.