How to connect to mysql database from power Bi

+2 votes
How to connect to mysql database from power Bi?
Mar 22, 2019 in Power BI by Anitha
25,756 views

1 answer to this question.

+2 votes

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 ?

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

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.

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.
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.
You've installed the connector, that's perfect. Have you configured it?

Related Questions In Power BI

0 votes
1 answer

How to connect to IBM DB2 database from power Bi?

Hi, Hi, Follow these steps, to connect to IBM ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
11,851 views
0 votes
1 answer

How to connect to sql server from power Bi?

Hi, Follow these steps to connect to SQL ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
1,290 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,350 points
1,922 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

answered Aug 23, 2019 in Power BI by anonymous
• 33,030 points
6,565 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,250 points
1,239 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,370 points
12,868 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,370 points
2,289 views
0 votes
1 answer
0 votes
1 answer

How to connect to sap Hana database from power Bi?

Hi, Follow these steps to connect to data ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 33,030 points
7,596 views
+1 vote
3 answers

How to connect to oracle database from power Bi?

I use Devart ODBC drivers in order ...READ MORE

answered Dec 20, 2019 in Power BI by Tony
• 160 points
30,569 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP