Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi community,
I have a MYSQL database installed on my system along with Power BI. I have been trying to connect the two together. Though it keeps asking me to install additional components before it can be used. I have installed the latest connector for 64-bit machine.
Still, it is not working. I am desperate for any help in connecting to the database. I am interning and power BI is a tool I am using, though I am having a serious issue accessing the database. please find below the image for the error
Solved! Go to Solution.
Hi @mayankkapoor85,
From the error message, it looks like you didn't install the correct MySQL connector successfully. You can download the ODBC Driver for MySQL(connector/ODBC) from below link, this connector worked well in my environment.
Also, here is a similar thread for your reference: Cannot connect to local MySQL database
Regards,
Yuliana Gu
Did you find the solution. Please help.
Hi @mayankkapoor85,
From the error message, it looks like you didn't install the correct MySQL connector successfully. You can download the ODBC Driver for MySQL(connector/ODBC) from below link, this connector worked well in my environment.
Also, here is a similar thread for your reference: Cannot connect to local MySQL database
Regards,
Yuliana Gu
Check your connector version/type and also ensure you install it via MSI option.
Below should be the one you need.
mysql-connector-net-6.6.5.msi
https://dev.mysql.com/downloads/file/?id=412152
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |