Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |