PowerBi Report Server Schedule Refresh Error with MySQL
Hello All, i have an issue in powerbi report server while setting up schedule refresh for multiple reports, I set the connection credentials for mysql database normally and try testing the connection and everything works fine but when the schedule refresh fires i receive the below error: SessionID: 984a1806-ce1e-4d00-b802-f94f76b496f1 [0] -1055784932: MySQL: Retrieval of the RSA public key is not enabled for insecure connections.. The exception was raised by the IDbCommand interface. [1] -1055129594: The current operation was cancelled because another operation in the transaction failed. [2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.