Forum Discussion
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 ...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi 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