Hi, I have built a semantic model on a MySQL cloud database.Works fine in Power BI desktop. Refreshing from the cloud fails with the error message"The MySql source doesn't support encrypted connections."Following the docs, I have set-up a connection via Manage connections and gateways, which seems to connect successfully: Settings: Refresh fails dough: In power query, I removed the ReturnSingleDatabase=true option but has no impact. let Source = MySQL.Database("server_ip", "cloud_db"), items = Source{[Schema="cloud_db",Item="items"]}[Data] in items Anybody knows how to solve this? I really need my model to refresh on a daily basis...

Posted by Micro Bot

29 Nov, 2024

Updated at 13 Dec, 2024

Cannot refresh semantic model on MySQL (cloud) - import

Hi,

I have built a semantic model on a MySQL cloud database.
Works fine in Power BI desktop. Refreshing from the cloud fails with the error message

"The MySql source doesn't support encrypted connections."

Following the docs, I have set-up a connection via Manage connections and gateways, which seems to connect successfully:

Screenshot 2024-11-29 at 09.34.29.png

Settings:

Screenshot 2024-11-29 at 11.24.13.png

Refresh fails dough:

Screenshot 2024-11-29 at 09.35.27.png

In power query, I removed the ReturnSingleDatabase=true option but has no impact.

let Source = MySQL.Database("server_ip", "cloud_db"), items = Source{[Schema="cloud_db",Item="items"]}[Data] in items

Anybody knows how to solve this? I really need my model to refresh on a daily basis...