Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |