Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
imj00
New Member

How to connect to a datasource with SSL

Hello Guys! I'm trying to connect to a datasource (MySQL Database) that uses SSL.

 

Question 1: How can I input the SSL Certificate.

Question 2: When trying to get data to that datasource it throws an error "MySQL: Reading from the stream has failed" I am guessing that this is due to the SSL Certificate that is required to connect to that db.

 

Thanks in advance

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi,

recently I am trying to connect (Azure Database for MySQL server) which is SSL connection based for powerBi refresh scheduler.

but i am unable to connect, it is asking for SSL connection is required. please specify ssl connection and try again.

1. I am not getting how to provide ssl connection in powerBi.

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @imj00 ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Has anyone been able to get this working?  I click go to solution and it loops back to th question.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors