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?
Power BI, on-premises data gateway (personal mode) and MySQL - Invalid connection credentials
Hi all I'm using Power BI to fetch data from a MySQL database (running on AWS) via the on-premises data gateway (personal mode) + MySQL connector NET installed on Azure VM (running on Windows Server 2022). On power BI (app.powerbi.com), the gateway is up and running but when I configure the data source credentials (with parameters server, database, authentication method - basic, username, password, tried encyption on and off for MySQL database) I get the following error: Unable to update connection credentials. Invalid connection credentials. Details: : The credentials provided for the MySql source are invalid. (Source at ***********.) Please have this information handy if you choose to create a support ticket. Session Id: 2cf0ede6-52e0-45a7-82dc-1775f919a1ac RequestId: 10ffc280-fc69-4ebd-b6d5-a1d760716d9c Cluster URI: https://api.powerbi.com Status code: 400 Time: Fri Nov 10 2023 16:01:53 GMT+0000 (Greenwich Mean Time)Please have this information handy if you choose to create a support ticket. Session Id: 2cf0ede6-52e0-45a7-82dc-1775f919a1ac Cluster URI: https://api.powerbi.com Time: Fri Nov 10 2023 16:01:53 GMT+0000 (Greenwich Mean Time) On-premises Virtual network Interestingly, when I had the exact same setup on my Windows 10 machine (on-premises data gateway (personal mode) + MySQL Connector Net) talking to same MySQL database on AWS mentioned above, everything worked fine. Could someone please help? Many thanks.
scheduled refresh error
i have a report with a mysql connection in import mode on power bi desktop i publish my report on power bi server but i have a problem during scheduled refresh. error message in picture please note that i'm using older versions of power bi desktop (january 2020) and power bi server (january 2020) I'd like to solve this problem without having to update.MySQL Connector Not Working
I'm having issues with the MySQL Connector on my machine. I've tried installing Connector/NET 8.0.32 and 8.0.28, but both have thrown me the same error. Other threads have said to downgrade, but those threads also mentioned "8.0.28" worked for them. Is there a known reliable version I can install? Or is this error becing caused by something else?
