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?
Problem with my gateway connection on windows VM
Unable to update connection credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue. Details: Spot_Data_VM: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. Please have this information handy if you choose to create a support ticket. In my laptop the gatewqy work well, but when I installed a new on my windows VM. I got this massage! and I checked all the connections, my mysql workbech can connect to the database throw the VM... Someone knows how to help me please?
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?
