Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi people,
I've been trying to connect in a DB in MySQL and I haven't been able to solve this trouble.
The MySQL connector was installed successfully and when I try to establish the connection I receive the error below:
"Connection option 'server' is duplicated"
I've found the reference here: https://community.powerbi.com/t5/Desktop/Unable-to-build-up-connection-with-MySQL/td-p/1125519 although this haven't solved my problem. I also tried to clean all the connection in the PowerBI but the same error continues appearing.
Does anyone have an idea on how to solve this trouble?
Thank you 🙂
Solved! Go to Solution.
I've solved this situation by doing 2 steps:
First - I've removed the connector on version 8.0.20 and I've installed version 8.0.15. After these installation different errors begin to show, such as "Unable to connect to any of the specified MYSQL Hosts".
Second - I've changed the way to connect on the DB. I've been tried as 'xxx.xxx.xxx.xxx,xxxx' and I've changed to 'xxx.xxx.xxx.xxx:xxxx' replacing the comma with a colon (important: I've had tried this before installing the version 8.0.20 and it hasn't worked, just with the version 8.0.15 everything worked well)
Thanks to @v-deddai1-msft and @lbendlin for your answers 🙂
I've solved this situation by doing 2 steps:
First - I've removed the connector on version 8.0.20 and I've installed version 8.0.15. After these installation different errors begin to show, such as "Unable to connect to any of the specified MYSQL Hosts".
Second - I've changed the way to connect on the DB. I've been tried as 'xxx.xxx.xxx.xxx,xxxx' and I've changed to 'xxx.xxx.xxx.xxx:xxxx' replacing the comma with a colon (important: I've had tried this before installing the version 8.0.20 and it hasn't worked, just with the version 8.0.15 everything worked well)
Thanks to @v-deddai1-msft and @lbendlin for your answers 🙂
Thanks
Hi @Anonymous ,
Would you please try to update your desktop to the latest version and re-install the connector: https://dev.mysql.com/downloads/connector/net/.
If the issue is still exist, I suggest you try to open a support ticket. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Best Regards,
Dedmon Dai
can you show a sanitized version of your Power Query connection code?
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |