• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

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...