Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vcarazo
Regular Visitor

Power BI Report Server can not connect to MySQL v8

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

4 REPLIES 4
v-xiandat-msft
Community Support
Community Support

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 @v-xiandat-msft,

 

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

Syndicate_Admin
Administrator
Administrator

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

v-xiandat-msft
Community Support
Community Support

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:

dev.mysql.com

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.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors