In this tutorial, it elaborates, how to connect MySQL Database source with Power BI tool. As a prerequisite, you have to install MySQL and Power BI in your local machine.
Step 1: Open Power BI goto Get Data --> More Select MySQL database
Once you click connect, you might get the following error,
"The connector requires one or more additional components to be installed before it can be used."
In this Case - Click Learn More link and it will direct to MySQL connector for the .net page: https://dev.mysql.com/downloads/connector/net/
Install this and restart the computer.
Step 2: Now once you press connect in Power BI, it will prompt following to connect to MySQL
Step 3: Type MySQL server as 'localhost' and your database schema, in my case, it is 'geekdecorders' as in the following image (this images taken from MySQL workbench)
Step 4: Load the MySQL table in Power BI
Step 5: As you can see in the field section, MySQL table columns appeared.
Step 6: Now drag and drop the columns to the Power BI worksheet.
Now you try adding/editing the data in MySQL and see how it changes.
Step 1: Open Power BI goto Get Data --> More Select MySQL database
Once you click connect, you might get the following error,
In this Case - Click Learn More link and it will direct to MySQL connector for the .net page: https://dev.mysql.com/downloads/connector/net/
Install this and restart the computer.
Step 2: Now once you press connect in Power BI, it will prompt following to connect to MySQL
Step 3: Type MySQL server as 'localhost' and your database schema, in my case, it is 'geekdecorders' as in the following image (this images taken from MySQL workbench)
Step 4: Load the MySQL table in Power BI
Step 5: As you can see in the field section, MySQL table columns appeared.
Step 6: Now drag and drop the columns to the Power BI worksheet.
Now you try adding/editing the data in MySQL and see how it changes.
Make sure you install the .NET libraries. The first time, I only installed ODBC and MySQL for Excel but the error didn't go away.
ReplyDeleteYes that's true.
DeleteWhere to get these?
DeleteGreat Post with valuable info. Thank you for the updates.
ReplyDeleteLearn Dot NET Online
dot net certification course online
Its very informative blog and useful article thank you for sharing with us , keep posting learn more about mulesoft online training in India | mule 4 online training
ReplyDeleteI feel SQL, power BI and other tools like these are actually very helpful to provide for more and more aspects of this.
ReplyDeletePowerbi Read Rest
IntelliMindz is the best IT Training in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.
ReplyDeletePower BI Online Training
Power BI Course In Bangalore
Power BI Training In Chennai
Great blog.thanks for sharing such a useful information
ReplyDeleteSalesforce CRM Training in Chennai
Thank you very much
ReplyDeleteGreat Article. Thank you for providing such a unique and valuable information to your readers. I really appreciate your work.
ReplyDeletePTE Coaching in ambala
Best IELTS Institute in Ambala City
Best IELTS Coaching in Ambala cantt
IELTS
Hi, After downloading the connector.net MSI installer during installation its asked me 3 options: Change, Repair, Remove. which one option should I go for? or should I first manually remove the connector.net from the system and then to try this with this one ?
ReplyDeleteI have downloaded the one which u added here in screenshot ( followed by learn more button from POWER BI). Please suggest which one option I should go for?
Deletenice.........!
ReplyDeletemicro strategy certification training