Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
Its already solved.
i just wrote ip : port and it worked.