topic Re: PowerBi Report Server Schedule Refresh Error with MySQL in Report Server

PowerBi Report Server Schedule Refresh Error with MySQL

Anonymous — Sat, 19 Mar 2022 13:55:11 GMT

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.

Re: PowerBi Report Server Schedule Refresh Error with MySQL

FarhanAhmed — Mon, 21 Mar 2022 04:18:32 GMT

Not sure if this is same as yours, this is in investigating mode though

Power Bi mysql data refresh failing asking for RSA... - Microsoft Power BI Community

Re: PowerBi Report Server Schedule Refresh Error with MySQL

Anonymous — Wed, 23 Mar 2022 08:44:02 GMT

Hi Anonymous ,

If you are a new MySQL user with Power BI, be sure to create a username within the database and execute a “GRANT PRIVILEGES” command for the username to give it read permissions.

During my investigation, I found that some users solved this problem using the following

“You should add client option to your mysql-connector allowPublicKeyRetrieval=true to allow the client to automatically request the public key from the server. Note that allowPublicKeyRetrieval=True could allow a malicious proxy to perform a MITM attack to get the plaintext password, so it is False by default and must be explicitly enabled.”

https://mysql-net.github.io/MySqlConnector/connection-options/

For more information，you can refer to this .

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: PowerBi Report Server Schedule Refresh Error with MySQL

Anonymous — Wed, 23 Mar 2022 08:47:37 GMT

Hello caitlyn,

how can i add allowPublicKeyRetrieval=true in PowerBi?

Re: PowerBi Report Server Schedule Refresh Error with MySQL

Anonymous — Wed, 23 Mar 2022 09:15:18 GMT

Hi Anonymous ,

My bad, this seems to be used for other mysql connectors, please try referring to the link in SU's first reply and see if that method fixes your problem. I can't help any farther. I have not meet this problem before and cannot reproduce it, looking forward to having another expert in RS to solve your problem.

Best Regards,
Community Support Team _ Caitlyn