Forum Discussion
Data 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")
Try explicitly setting the connection string to not use SSL by adding SslMode=none; to it.
Example: Server=yourserver;Database=yourdatabase;User=youruser;Password=yourpassword;SslMode=none;
Can you clarify where I could do that? I am using power query to query the data. I am connecting it to the mysql database. MySQL.Database("rm XXXXXX", "coordination", [ReturnSingleDatabase=true])
MySQL.Database("rm XXXXXX", "coordination", [ReturnSingleDatabase=true, Encrypted=false, SslMode="none"]) ])I 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)