How to connect to mysql database from power Bi?

0 votes
How to connect to mysql database from power Bi?
Mar 22 in Power BI by Anitha
1,118 views

1 answer to this question.

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

answered Mar 22 by Cherukuri
• 25,900 points

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 in Power BI by Cherukuri
• 25,900 points
606 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 in Power BI by Cherukuri
• 25,900 points
66 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
• 40,460 points
226 views
0 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 in Power BI by anonymous
• 25,900 points
29 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,130 points
43 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 darklord
• 6,140 points
1,949 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 darklord
• 6,140 points
242 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 in Power BI by Cherukuri
• 25,900 points
523 views
0 votes
1 answer

How to connect to oracle database from power Bi?

Hi, 1. Click on Get Data. 2. Go to ...READ MORE

answered Mar 22 in Power BI by Cherukuri
• 25,900 points
1,211 views