Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

Data Gateway - MySql dataset refresh error - The MySql source doesn't support encrypted connections.

Hi,

 

I have a very frustrating problem that I can't manage to understand or get around. I have a report that uses a MySql data source. I deploy it to cloud powerBI and use the on premise data gateway to connect to it. This particular report throws out this error:

 

Invalid connection credentials.
Please try again later or contact support. If you contact support, please provide these details.

 

Underlying error code -2147467259
Underlying error message The MySql source doesn't support encrypted connections. (Source at <removed>.)
DM_ErrorDetailNameCode_UnderlyingHResult -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind MySql
Microsoft.Data.Mashup.CredentialError.DataSourcePath<removed>
Microsoft.Data.Mashup.CredentialError.Reason EncryptedConnectionFailed
Cluster URIWABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID1e295340-c1a8-4377-9414-d97e4dde1869
Request ID8b452c72-2255-03bc-f6fb-5044397aa9ad
Time2017-02-07 11:22:54Z

 

This is very frustrating because I'm using the exact same source through the exact same gateway in a different report and that one is working just fine. The MySQL source does support encrypted connections also. So the error doesn't even make sense.

 

I've tried the following:

1. Redeploying the report

2. Recreating the data source in the manage gateway page

3. Restarting the data gateway

4. Clearing up the permissions in the data source settings of the report and adding them again

5. Tried changing the name of the data source (you can't do that in power bi desktop si I just appended to port at the end in hopes of tricking it)

 

I just can't figure out what the problem might be:(

 

data gateway version: 1.15.6170.1

mysql connector net: 6.6.5

power bi desktop: 2.42.4611.701 64-bit (January 2017)

windows server 2016 

 

At this point im desperate vor ANY ideeas!

Thank you!

Andrei  

 

Full error logs from the data gateway:

DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2523736Z DM.EnterpriseGateway bc28a748-1625-412e-9dc3-f1008587af23 6f93a005-b7ca-4c85-a924-954ef2624146 MGEA 8dcd056a-dd80-497a-bb1e-02c3239cced6 D88DD922 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The MySql source doesn't support encrypted connections. (Source at<removed>)
at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2523736Z DM.EnterpriseGateway bc28a748-1625-412e-9dc3-f1008587af23 6f93a005-b7ca-4c85-a924-954ef2624146 MGEA 8dcd056a-dd80-497a-bb1e-02c3239cced6 D0174D8B [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=150, err=MashupCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 87BAEBB0 [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessCredentialException: Missing or invalid credentials for data source. Reason = 'EncryptedConnectionFailed', DataSource = 'MySql/<removed>', DataSourceReference = '', DataSourceOrigin = '', DataSourceReferenceOrigin = ''.; ErrorShortName: MashupDataAccessCredentialException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(MashupCredentialException)[ErrorCode=-2147467259,HResult=-2147467259]
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 8AA61592 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 0834FCD8 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <pi><pi>The MySql source doesn't support encrypted connections. (Source at<removed>)</pi></pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 6A5E25DC [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingHResult = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 6D769432 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.DataSourceKind = <pi>MySql</pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 75291C07 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.DataSourcePath = <pi><removed></pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 D87BB53A [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.Reason = <pi>EncryptedConnectionFailed</pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 9DD226C9 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=868, err=MashupDataAccessCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 4f655709-8eda-4676-9c0e-70d45c0f834c 6f93a005-b7ca-4c85-a924-954ef2624146 MGPE 8dcd056a-dd80-497a-bb1e-02c3239cced6 9DD226C9 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=868, err=MashupDataAccessCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Information: 0 : 2017-02-07T08:02:02.2583631Z DM.EnterpriseGateway 143e92c3-1b5a-4629-8d89-fde9169cbef6 6f93a005-b7ca-4c85-a924-954ef2624146 MGPP 8dcd056a-dd80-497a-bb1e-02c3239cced6 ABE5CED4 [DM.GatewayCore] Async operation 80301c2e-7ddb-4a7e-9e4c-38d804d09b33 completed with an error: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessCredentialException: Missing or invalid credentials for data source. Reason = '<pi>EncryptedConnectionFailed</pi>', DataSource = '<pi>MySql/<removed></pi>', DataSourceReference = '', DataSourceOrigin = '', DataSourceReferenceOrigin = ''.

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_InvalidConnectionCredentials
Reason=<pi>EncryptedConnectionFailed</pi>
DataSource=<pi>MySql/<removed></pi>
DataSourceReference=
DataSourceOrigin=
DataSourceReferenceOrigin= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupCredentialException:<pi>Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The MySql source doesn't support encrypted connections. (Source at<removed>.)
at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<<ExecuteAdoQuery>b__19>d__27.MoveNext()</pi>

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
InnerType=MashupCredentialException
InnerMessage=<pi>The MySql source doesn't support encrypted connections. (Source at<removed>.)</pi>
InnerToString=<pi>Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The MySql source doesn't support encrypted connections. (Source at<removed>.)
at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<<ExecuteAdoQuery>b__19>d__27.MoveNext()</pi>
InnerCallStack= at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<<ExecuteAdoQuery>b__19>d__27.MoveNext()
([1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException.StackTrace:)
at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()

Status: Delivered
Comments
v-haibl-msft
Employee

@Nadejde

 

I found a similar issue which reported internally before. The product team confirmed that encrypted connections aren't supported using the built-in MySQL connector.

 

The customer may find that they can use the generic ODBC connector with a MySQL ODBC driver to achieve their aims, though the user experience around that is admittedly not as good. The underlying issue is that we don't currently have any way for the user to indicate that they trust the certificate. The server is probably using a self-signed certificate without a trust chain back to a CA, so it fails the certificate check in the SSL stack.

 

Supporting this scenario is on the roadmap for the first half of CY2017, but there's work that needs to be done by partner teams too so it's not a given that it will be done in that timeframe.

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Status changed to: Delivered
 
Nadejde
Regular Visitor

Hi, 

 

Thank you for your answer. There must be something else going in. The server secured with a properly signed SSL certificate not a self-signed one.

 

What throws me completely is how the same connection works on some reports and not on others. I've rebuilt the report that was causing problems from scratch in the meantime and it is now working, while the previous one keeps throwing the same error. I can provide these and more details if you think it could help the development team let me know.

 

Regards,
Andrei N.

 

 

kschneider
New Member

We are experiencing a similar issue.  If you did resolve this how?

datavigilante
Helper I

I had the exact same message and it turned out that it had nothing to do with the connection being encrypted or not.  (I unchecked "Encrypt connections" box in the data source settings)

 

I have a number of process-intensive views in my data source which take a long time to refresh.  Further, I had two datasets scheduled to refresh from this data source at the same time, which caused them to fail with the "The MySql source doesn't support encrypted connections" error. 

 

Simply staggering the refresh schedule of these datasets resolved this problem for me.

 

Hope it helps and good luck!

David

he9817
Regular Visitor

we are experience similar issues with python. If you resolved it how?