The MySql source doesn't support encrypted connections when using cloud connections

[frankwangtakumi]

Hi, I'v been looking how to deal with this for quite long, hoping can get any ideas here:

I connecting my sql database from colud server, in power desktop, everything works fine, including refreshing. But when it published, the refreshment does not work with this error message: The MySql source doesn't support encrypted connections.

Looking back to my other old reports, I found that they were using on-premises gateway as long as the dataset published. But now, seems it will automaticlly using cloud connections in stead of on-premises gateway, and this is why the refreshing not work.

But when i try to change it into on-premises, and  it seems not possible. 

Is it possible to shut down cloud connections? Or moving this connection to gateway?

[tom_pykes]

Hi, I have the same issue, anybody found a solution for this?
Enabling Encryption on the server is not an option for me

[vinodunny]

I'm having the same issue. The MySQL db I'm connecting to doesn't have encryption enabled. I've set the "Encrypted Connection" to "Not Encrypted" and Privacy Level to "Public". 

On attempting a refresh, the Power BI Service tries for a few minutes and then gives the error "The MySql source doesn't support encrypted connections. ". 

Any other setting gives this error almost immediately. 

[lbendlin]

Use a gateway and disable the encryption check on it.

[lbendlin]

go into the next section and check if you have any triangles in the credentials list.

[frankwangtakumi]

Seems ok with all the credentials. Is it a new feature that power bi now leading to cloud connections directly if the database is from the cloud?

[johnbasha33 · Accepted solution]

@frankwangtakumi  yes, for cloud connections, we dont need a gateway but need a cloud connection setup. it is a new feature in Power BI. 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[frankwangtakumi]

After setting up encryptting for database, this issue solved. Thanks,

[KossXL]

Hey, everybody. I don't use encryption and still get this error.
How to fix it?

The MySql source doesn't support encrypted connections.

[Lucas_Zani]

Como você realizou a configuração?