Forum Discussion

davestasiuk's avatar
davestasiuk
New Member
9 years ago
Solved

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 ha...
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

archinate's avatar
archinate
Regular Visitor
9 years ago

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.