Invalid Credential when SSL is enabled in MySQL

[Anonymous]

Hi,

We just enabled SSL in our server with MySQL database.

In Power BI Desktop, it gives an error of "Invalid Credentials"

This issue is fixed by ticking the checkbox Enable Encryption in the data source permission settings.

We then saved and published the report to Power BI service.

The error of "Invalid Credentials" occurs again in the Power BI service.

How to enable encryption in Power BI service?

For now, we have turned off the SSL in the server, and our Power BI service is connecting ok.

Many thanks.

[v-xicai]

Hi @Anonymous ,

It is not supported to apply SSL certificate for MySQL database in Power BI Service currently .There is an idea about this issue, please vote it up, SSL Certificate on MySQL connection , to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

Best Regards,

Amy

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