Connect Power BI with MySQL Database

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. 

Comments

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

    ReplyDelete
  2. 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

    ReplyDelete
  3. I feel SQL, power BI and other tools like these are actually very helpful to provide for more and more aspects of this.

    Powerbi Read Rest

    ReplyDelete
  4. IntelliMindz is the best IT Training in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.

    Power BI Online Training
    Power BI Course In Bangalore
    Power BI Training In Chennai

    ReplyDelete
  5. Great Article. Thank you for providing such a unique and valuable information to your readers. I really appreciate your work.

    PTE Coaching in ambala
    Best IELTS Institute in Ambala City
    Best IELTS Coaching in Ambala cantt
    IELTS

    ReplyDelete
  6. 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 ?

    ReplyDelete
    Replies
    1. I 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?

      Delete

Post a Comment