Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Best Regards
Sebastian
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.
@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
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |