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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
pellon
New Member

Problem connecting with mysql

Hi

 

I have problems to connect with a mysql databse, i have already red many topicss about this issue but it is still not working... 

i go to get data-mysql database, then in Server i write the  server IP and the database name.

 

I go to database (instead of windows option) and then i fill username and password (same ones used for the odbc connection) and i get the following error: "we couldnt authenticate with the credentials provided. Please try again"

 

Both odbc for 32 and 64 bits connections are working (Test in odbc connector states that connection works), i am using same user name and password (copy-pasted them). The most surprising thing for me is that i can connect and use queries for the same database in an excel file, so it should be any odbc connection issue (as i have read is the most common issue)

 

The database i am connecting to has to be accesed via port 33306 instead of default 3306. The odbc connections are set up with 33306 and no problem, i dont know if this is the cause of the problem, cause i see no option to change connection port in power bi...on the other hand, is possible to set the connection with the dsn instead of the ip?

 

Thanks!

1 ACCEPTED SOLUTION
pellon
New Member

Its already solved.

i just wrote ip : port and it worked.

View solution in original post

1 REPLY 1
pellon
New Member

Its already solved.

i just wrote ip : port and it worked.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.