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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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