Good day everyone,
I currently have a most courious problem on hand. I have a local Data Gateway. On this gateway I have created a connection to a AWS MySQL Database. This connection works in the cloud (or at least I though so) correcly, the Power BI test connection worked etc.
Now I have some reports that use this connection, most of which work correctly. I have two reports though, that throw this error 95% of the the times.
Its not 100% of the time, since I had a signular refresh come through yesterday, after which it did not work anymore again.
Locally it refreshes correctly.
I already updated the local gateway to the newest, updated the MySql driver.
Im out of ideas, what could cause this. Error is attached.
{"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 [Redacted])"}},{"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":"[Redacted]"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"EncryptedConnectionFailed"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"MySql\",\"path\":\"[Redacted]"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"EncryptedConnectionFailed"}}],"exceptionCulprit":1}}} Table: [Redacted].
Every help is appreciated.
