The MySql source doesn't support encrypted connections when using cloud connections
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?
Mysql db cannot access or establish a connection through power bi
Dear Experts I’m trying to access MySQL db located on digital ocean cloud , My SQL Server available on PHP MyDAMIN please check the scree-shot below: Now I’m trying to access MySQl DB through power bi I got the following error: I downloaded My SQL connector from this link: https://dev.mysql.com/downloads/installer/ I install it (the connection) but I have the same error , please advice me how to solve this problem?
