See post from 2017 with same issue.
Data Gateway - MySql dataset refresh error - The M... - Microsoft Fabric Community
Using MySQL Connector Net 8.0.28 on Gateway and Desktop (latest version of connector does not connect to Localhost Mysql).
MySQL sits in: Azure Database for MySQL servers
I have a dashboard which uses MySQL as the datasource. With a small dataset of 1000 rows, the dashboard refreshes successfully on Powerbi.com and from Desktop.
In the same dashboard, with the same dataset a test of 100k rows fails to refresh from Powerbi.com and from Desktop.
When the same MySQL source in the dashboard increases to 100k rows then receive the error:
Data source error{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The MySql source doesn't support encrypted connections. (Source at abc.azure.com;my_db.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"abc.azure.com;my_db"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"EncryptedConnectionFailed"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"MySql\",\"path\":\"abc.azure.com;my_db\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"EncryptedConnectionFailed"}}],"exceptionCulprit":1}
Note occossionaly the dashboard will refresh with the larger dataset with no connection error.
