Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 connectio...
Power Bi Scheduled Task
PowerBI Report Server
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello caitlyn,

    how can i add allowPublicKeyRetrieval=true in PowerBi?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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