Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
s_kula
Helper I
Helper I

MySql serwer connection problem

Hello, I have a problem connecting to MySql database via Power Bi. Using the same access data, I am able to log in directly to the server via phpMyAdmin. Can anyone tell what mistake I am making?

 

screen 16.01.JPG

 

Best Regards

Sebastian

3 REPLIES 3
s_kula
Helper I
Helper I

Hello, I have a problem with connecting to the database via Power BI.
I can log in to the database via PhpMyAdmin, but I want to connect via Power BI.

Login to the server is done via port :8080 PMA.

Have any of you connected to the database like this?
I heard that the solution might be to configure the connection via ODBC? Unfortunately, I don't know how to configure it.

amitchandak
Super User
Super User

@s_kula , Connection details are not correct.

Also, make sure latest .net driver is installed

 

https://dev.mysql.com/downloads/connector/net/

Hello, yes I know the access details are incorrect.
However, I do not know exactly what data should be entered.
As I said, I have no problem logging directly into the database.
Can I view the data that should be used to log in via Power Bi in the phpMyAdmin panel?

The drivers are updated to the latest version.

 

Sebastian

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.