Forum Discussion

chenishere's avatar
chenishere
New Member
8 years ago

How to connect database to Power Bi using IP address？

Hi, im using mysql workbench and im able to connect to the database using IP as shown below 

 

but i dont know how to do it in Power BI,  it doesnt work when I try to connect it this way 

 

Kindly help me. thanks 

3 Replies

  • mgmeyer's avatar
    mgmeyer
    Power BI Team
    8 years ago

    If your database is MySQL then your using the wrong connection type, the one you have below is for SQL Server. In Power BI Desktop on the Get Data dialog you should see an option for a MySQL Database connection, try that as let me know if that works.

    • chenishere's avatar
      chenishere
      New Member
      8 years ago

      thanks for the reply. I tried but it showed this error

       

       

       

      isnt there like an option to input IP address, database name, username and password? 

      pls help 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi chenishere,

     

    Similar to SQL Server, the connection dialog for MySQL Database also allows users to enter Server Name or IP address, as shown in below image:

     

    Please be aware that before you can connect to a MySQL database, you have to install MySQL Connector/Net 6.6.5 for Microsoft Windows. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).

     

    To correctly connect to MySQL DB from Power BI desktop and troubleshoot the error you encountered, please see this blog:

    Power BI Tips for Working with MySQL

     

    Best regards,
    Yuliana Gu