Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.