Forum Discussion
How to connect to a datasource with SSL
Hi imj00 ,
Normally, there is no SSL certification when you connect My SQL Database in Power BI Desktop.
When the "encrypt connection" option is selected -- which it is by default -- the connection won't be established unless there's a server-side SSL certificate. This should ensure that the data is encrypted.
Have you used SSL certification when you use My SQL Database?
If not, you should configure MySQL to Use Encrypted Connections firstly. Please refer to this article.
In addition, make sure that the certificate used by your data source is within the Trusted Root Certification Authorities store of the machine running the Power BI gateway, there is an old blog stating this process.
After installing SSL certificate, add your data source within gateway.Moreover, there is a similar thread you could refer to.
Hope this can make sense of you!
Best Regards,
Cherry
Hi imj00 ,
Normally, there is no SSL certification when you connect My SQL Database in Power BI Desktop.
When the "encrypt connection" option is selected -- which it is by default -- the connection won't be established unless there's a server-side SSL certificate. This should ensure that the data is encrypted.
Have you used SSL certification when you use My SQL Database?
If not, you should configure MySQL to Use Encrypted Connections firstly. Please refer to this article.
In addition, make sure that the certificate used by your data source is within the Trusted Root Certification Authorities store of the machine running the Power BI gateway, there is an old blog stating this process.
After installing SSL certificate, add your data source within gateway.
Moreover, there is a similar thread you could refer to.
Hope this can make sense of you!
Best Regards,
Cherry
Has anyone been able to get this working? I click go to solution and it loops back to th question.