Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @esakie ,
The error message indicates that the MySql source doesn’t support encrypted connections. Let’s explore some potential solutions:
Check Encryption Settings:
Gateway Version Compatibility:
Below is the post will help you:
Solved: Power BI Gateway MySQL source doesn't support encr... - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |