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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.