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.

  • archinate's avatar
    archinate
    Regular Visitor
    9 years ago

    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's avatar
    davestasiuk
    New Member
    9 years ago

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

    • MarkEvansHW's avatar
      MarkEvansHW
      Icon for Helper II rankHelper II
      8 years ago

      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's avatar
      MarkEvansHW
      Icon for Helper II rankHelper II
      8 years ago

      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's avatar
        Arranafc19
        Icon for Helper IV rankHelper IV
        8 years ago
        Did you manage to resolve this ?