Cannot refresh semantic model on MySQL (cloud) - import

[tom_pykes]

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

Spoiler

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

[Anonymous]

Hi, @tom_pykes

Maybe you can  try restarting the MySql server or setting up database encryption. You can refer to the following posts:

Solved: Power BI Gateway MySQL source doesn't support encr... - Microsoft Fabric Community

Solved: The MySql source doesn't support encrypted connect... - Microsoft Fabric Community

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tom_pykes]

Hey,

The server has been restarted over the weekend and that didn't solve anything.

The MySQL-instance is hosted by the ERP provider, so I am not entitled to set-up encryption on it. But I shouldn't, as Power BI provides the option not to use it.

I don't use a gateway (as one can see in my initial screenshot), I use a cloud connection.

I have the feeling that it is a bug, seems like the Power BI service ignores the "Not encrypted" parameter, or is there anybody who succeeded in actually refreshing a model without encryption?

Guess my best option here is to set-up a gateway... ?

Cheers,

Tom

[arvindsingh802]

As this is cloud connection, you do not need gateway, have you tried connecting without gateway ?
Also one of blog suggested to reboot the MYSQL server, can you try that as well if possible. 

[tom_pykes]

Hi @arvindsingh802 ,

It is a cloud connection, not a gateway... setting up the connection works, refreshing the model doesn't