Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
When we connect to a MySQL v8 in SaaS through MySQL connector/NET power bi desktop allows us to indicate that the communication will be encrypted, and Power BI Desktop connects without problem to MySQL.
The problem appears when publishing the dashboard in Power BI Report Server, since when configuring the dashboard connection from the Power BI Report Server portal it does not connect to MySQL and the following error appears:
MySQL: Authentication to host 'XXXXXXXXXX for user 'OXXXXXX' using method 'mysql_native_password' failed with message: Connections using insecure transport are prohibited while --require_secure_transport=ON.
How can we force it to encrypt the connection?
Greetings,
Victor
Hi @vcarazo ,
Have you solved the current problem?
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous,
the problem still remains.
MySQL server is a SaaS service so I can not change the flag require_secure_transport to off.
Best Regards,
Victor
Hello
when we connect to a MySQL v8 in SaaS through MySQL connector/NET Power BI desktop allows us to indicate that the communication will be encrypted, and Power BI Desktop connects without problem to MySQL.
The issue appears when publishing the dashboard to Power BI Report Server, as configuring the dashborad connection from the Power BI Report Server portal does not connect to MySQL and the following error appears:
MySQL: Authentication to host 'XXXXXXXXXX for user 'OXXXXXX' using method 'mysql_native_password' failed with message: Connections using insecure transport are prohibited while --require_secure_transport=ON.
How can we tell or force you to encrypt the connection?
Best regards
Victor
I'm also wondering the same thing.
Hi @vcarazo ,
Use both:
config mysql system configuration (require_secure_transport=off)
Client connection to mysql server using SSL/TLS protocol configuration
Properly configure the MySQL server to support SSL connections. This includes having a valid server certificate
Below is the link will help you:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
1 |
User | Count |
---|---|
7 | |
6 | |
6 | |
4 | |
3 |