data refresh error
1 Topic
Data Refresh Failed: mysql doesn't support encrypted connections
Hi, I've been trying to fix this problem for a while, and I can't seem to find where the issue is. I have a report connected to Alibaba Cloud's mysql, and everything works fine in PowerBI desktop. I refresh the report and everything is okay. But once I published it to powerbi service and tried to refresh there, I get the following error message: "Data source error: The MySql source doesn't support encrypted connections. (Source at ......). The exception was raised by the IDbCommand interface." Currently, I am not using a data gateway, as I am aware that cloud connections don't require one. I've tried switching between encrypted and not encrypted connections, but the error remains the same regardless of which one I've switched on. I've also tried to use the on-premise data gateway instead, but I can't cuz I'm not an admin user. I am using power query to query the data with the mysql database. Here's the m query code: MySQL.Database("rm XXXXXX", "coordination", [ReturnSingleDatabase=true])Solved7.9KViews0likes10Comments