Forum Discussion

smallfires0628's avatar
smallfires0628
Helper I
2 years ago
Solved

Data Refresh Failed: mysql doesn't support encrypted connections

Hi,   I've been trying to fix this problem for a while, and I can't seem to find where the issue is. I have a report connected to Alibaba Cloud's mysql, and everything works fine in PowerBI deskto...
data refresh
Data Refresh Error
Mysql connection error
  • smallfires0628's avatar
    smallfires0628
    1 year ago

    Yes I found a solution. I have to specify for it to be non-encrypted. I do it by downloading the MySQL ODBC driver to control encryption settings.
    I specified the connection string through Power Query itself. Here's the m-query code:
    connectionString = "Driver={MySQL ODBC 9.0 Unicode Driver};Server=rm-XXXXX;Database=...;User=...;Option=3;SslMode=DISABLED;",
    Source = Odbc.Query(connectionString, "SELECT * FROM table")

tom_pykes's avatar
tom_pykes
Regular Visitor
1 year ago

Hi smallfires0628 

 

Have you found a solution to this? Stuck on exactly the same issue...

 

Kind regards,

Tom

smallfires0628's avatar
smallfires0628
Helper I
1 year ago

Yes I found a solution. I have to specify for it to be non-encrypted. I do it by downloading the MySQL ODBC driver to control encryption settings.
I specified the connection string through Power Query itself. Here's the m-query code:
connectionString = "Driver={MySQL ODBC 9.0 Unicode Driver};Server=rm-XXXXX;Database=...;User=...;Option=3;SslMode=DISABLED;",
Source = Odbc.Query(connectionString, "SELECT * FROM table")

  • tom_pykes's avatar
    tom_pykes
    Regular Visitor
    1 year ago

    Thanks for your quick response smallfires0628 !
    Works in PBI Desktop.
    This implies set-up of a gateway I guess?
    Or how do you connect from the service?

    • smallfires0628's avatar
      smallfires0628
      Helper I
      1 year ago

      I am using cloud connections, so no data gateway needed for that

      • tom_pykes's avatar
        tom_pykes
        Regular Visitor
        1 year ago

        Thanks so much for your replies.

         

        Ok, I see... it's a bit confusing in the settings interface.

         Details:

         

         


        Anyway, don't know if you got the same issue but it asks for credentials and doesn't want to save after I filled them in. Also, it gives the impression of wanting to use an on-premises gateway (grayed out)...

         

        What ODBC-version are you working on?
        Only difference with your query is the 9.0 vs 9.1 (only one available on Oracle)

         

         

         

        connectionString = "Driver={MySQL ODBC 9.1 Unicode Driver};Server=my_server;Database=my_db;User=my_user;Option=3;SslMode=DISABLED;",
Source = Odbc.Query(connectionString, "SELECT * FROM items")

         

         

        -> works fine in PBI Desktop