Forum Discussion
The MySql source doesn't support encrypted connections when using cloud connections
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 !!
Hallo Johnbasha- all,
I’m currently trying to automate the refresh of a dashboard connected to a MySQL database using Power BI Service (Online).
Although I have disabled encryption both in Power BI Desktop and in the Power BI Service data source settings, I still receive an error related to encrypted connections when trying to schedule or trigger a refresh online.
I've checked the following:
The connection works perfectly in Power BI Desktop.
Encryption is explicitly disabled in both environments.
The data gateway is correctly installed and running.
However, Power BI Service continues to reject the connection, assuming encryption is required.
I’ve tried many solutions but nothing worked so far.
Do you have any recommendations or workaround to solve this encryption conflict?
the issue msg "The MySql source doesn't support encrypted connections. (Source at X.XX.XXX.X:3306;xxx.). The exception was raised by the IDbCommand interface. Table:xxxx."
Thanks in advance,
It is a bug in Power BI service I guess
We have set-up a gateway on a VM and now it works
So PBI service -> gateway -> MySQL