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