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 all, i have power bi version 2.126.1261.0 and mysql server 8.0. I am trying to connect powerbi with mysql and getting an error. I initially thought that problem was related to mysql server so i tried to connect my sql server from dbveaver as well. I was able to do that but not with power bi. Can you help me please. been scratching my head over this for past week.
Hi, @jainanish
Make sure that this component is installed not only on the local machine running Power BI Desktop, but also on any computer that hosts the on-premises data gateway.
Check the SSL configuration, if the MySQL server has SSL enabled, you need to ensure that the SSL certificate is installed and configured correctly on the computer running Power BI Desktop. This step is essential to establish a secure connection. You can refer to the following link:
Solved: MySQL Connector Not Working - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jainanish See if this helps: tcp - Unable to Connect to MySQL local server 3306 in Power BI - Stack Overflow
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 |
---|---|
56 | |
20 | |
19 | |
18 | |
9 |