cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lladhuie Frequent Visitor
Frequent Visitor

Encryption Support

Hi,

 

I'm trying to connect PBI to Mysql database and have always the same message (mysql-connector-net-6.9.9 is already installed...)


Encryption Support.png

 

3 REPLIES 3
v-yulgu-msft Super Contributor
Super Contributor

Re: Encryption Support

Hi @lladhuie,

 

Please disable the Encrypt Connections. You can click OK button in error prompt dialog, you'll be directly prompted to turn off encryption. Or you can go to File->Options and Settings -> Data Source Settings, choose current data source and select Edit and uncheck "Encrypt Connections" option.

 

Here are two similar threads:

connect to SQL DB prompt "The data source you're trying to access doesn't support encrypt...."

Issue connecting to MySQL db through PowerQuery

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lladhuie Frequent Visitor
Frequent Visitor

Re: Encryption Support

Hi,

 

Thks a lot for your answer.

 

I've try your solution, ant dont have the message any more but don't connect to my bases....

when the encrypt connection is uncheck, PBI cannot authenticate with credentials provide.

when I try the login and password on phpmyadmin it works. So mysterious for me ! :-(

 

 

v-yulgu-msft Super Contributor
Super Contributor

Re: Encryption Support

Hi @lladhuie,

 

What error message did you get when you attempted to connect to MySQL DB after unchecking encrypt connection?

 

How did you connect to MySQL DB? Please provide more description about your operations.

 

Best regards,
Yuliana Gu

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 985 guests
Please welcome our newest community members: