Forum Discussion
Helper IData Refresh Failed: mysql doesn't support encrypted connections
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")
Memorable MemberMySQL.Database("rm XXXXXX", "coordination", [ReturnSingleDatabase=true, Encrypted=false, SslMode="none"])
])
Helper II tried but it sent me the following error:
DataSource.Error: MySQL: This function doesn't support the query option 'Encrypted' with value 'false'.
Details:
FALSE
DataSource.Error: MySQL: This function doesn't support the query option 'Sslmode' with value '"none"'.
Details:
none
It seems like both parameters don't work.
I am working with PBI Version: 2.131.1203.0 64-bit (July 2024)
Have you found a solution to this? Stuck on exactly the same issue...
Kind regards,
Tom
- smallfires0628
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")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?
