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

Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

We are having a connection issue between PowerBI to a MySQL server. Of the five people in our office, all of us are correctly connected in our MySQL Workbench, running queries, etc. Two of us have had no problem in connecting to the database in PowerBI, but the rest of us have been unable, and are receiving the following error: "An error happened while reading data from the provider: 'Authentication failed because the remote party has closed the transport stream.'" We have tried deleting our permissions and re-entering them, but to no avail. We have tested this connection using Tableau as well, and have been able to connect there...so we are all in with both MySQL Workbench and Tableau, but for some reason some of us cannot connect through PowerBI. Does anyone have any recommendations for how we can move forwared?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

Hi @davestasiuk,

 

I don't think this issue is caused by power bi. Based on research, it seems a like a specify device issue.

 

Does these issue only appear on specific devices?

If this is a case, I think the issue may related to your hardware driver, mysql software version, OS version and ssl provider.

 

In addition, I'd like to suggest you to post this to mysql forum to get further support.

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
9 REPLIES 9
Community Support Team
Community Support Team

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

Hi @davestasiuk,

 

I don't think this issue is caused by power bi. Based on research, it seems a like a specify device issue.

 

Does these issue only appear on specific devices?

If this is a case, I think the issue may related to your hardware driver, mysql software version, OS version and ssl provider.

 

In addition, I'd like to suggest you to post this to mysql forum to get further support.

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
archinate Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

I have been having the same issue as @davestasiuk on this. Re: connecting from PowerBI to a MySQL database.

 

Tableau, workbench, and even some custom software I am creating are all connecting successfully to the same MySQL database hosted on Azure. When I connect through PowerBI with the same DB credentials, "Remote Party Has Closed the Transport Stream" is given and I am unable to connect.

 

I have replicated the problem on other machines with fresh installations of PowerBI, etc too.

archinate Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

I came to the forum looking for a solution to this exact same problem described by @davestasiuk.

 

I am able to succesfully connect to the same Azure-hosted MySQL DB from Tableau, workbench, and some of my custom software. When I use the same login credentials with PowerBI, I get the same "Remote Party Has Closed the Transport Stream". This is true on other machines I am testing on as well.

 

Why would PowerBI not let me connect to the Azure DB, but other apps are successful on the same device, with the same creds, and drivers?

davestasiuk Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

Yes, it turned out to be related to the MySQLQ Connector.NET version.

MarkEvansHW Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

Any tips on how to solve it? Which version were you using? How did you determine which one to use? I'm having the same issue.

MarkEvansHW Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

Any tips on how to solve it? Which version were you using? How did you determine which one to use? I'm having the same issue.

Arranafc19 Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

Did you manage to resolve this ?
Arranafc19 Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

Did you find a solution to this ? I am getting the same issue currently
robertoz Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL Database: "Remote Party Has Closed the Transport Stream"

I got the same.

It helped me to update mySQL connector. I used MySQL Connector/.Net.