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.
I republished our pbix to the service and want to schedule a refresh against our gateway. This has been working for a few weeks, however now the datasets gateway option is greyed out. I believe its a problem with the datasource.
Under manage gateways, everything seems fine but under the covers something isn't working. The datasource settings look good, and re-entering the credentials connects fine. However re-saving the screen by changing the privacy level from Private to None and back again (enabling the Apply button) I get the exception - DM_GWPipeline_Gateway_BadUsernameFormat. I know the user and credentials are good too because if I enter an invalid password I get a different invalid credentials error. I believe this is why the gateway options are greyed out.
Any help troubleshooting why this is happening now when it worked fine before would be welcomed. Credentials are being entered as "DOMAIN\user"
Saving with credentials is successful
Re-saving fails
Hi @Anonymous,
What error are you seeing under the logs here:
C:\Users\PBIEgwService\AppData\Local\Microsoft\Power BI Enterprise Gateway\EnterpriseGateway*.log
Thanks,
Dimah
@dimazaid the logs look like (if you move to the farthest end of line 4) it has a credential issue. The strange thing is when I enter them initially it says connection successfully, but when I resave the screen I get the error. Any thoughts?
DM.EnterpriseGateway Information: 0 : 2016-05-25T21:16:00.4926248Z DM.EnterpriseGateway e72231bf-bc9d-4492-bcf8-b70e07949a78 e185d9b5-1280-33ac-13f3-dd4d07f4c689 MGPP 1ddd0949-c6c8-48f5-95de-385ea0662826 A08BF3B6 [DM.GatewayCore] Deserialized TestGatewayConnectionRequest, executing DM.EnterpriseGateway Information: 0 : 2016-05-25T21:16:00.6488210Z DM.EnterpriseGateway a6a9e414-3a93-4557-abf1-1b594f17eb61 2b7a982e-5a21-1ddb-f9fc-d4f8889cc014 MGPP 1ddd0949-c6c8-48f5-95de-385ea0662826 E3AA0EFB [DM.GatewayCore] Deserialized TestDataSourceConnectionRequest, executing DM.EnterpriseGateway Information: 0 : 2016-05-25T21:16:15.6023755Z DM.EnterpriseGateway c67306d3-71a9-449e-ac8b-9a300adfa16f 0c358dbf-397e-b1aa-b794-30c1cb9f35d0 MGPP 1ddd0949-c6c8-48f5-95de-385ea0662826 7683252B [DM.GatewayCore] Deserialized EncryptCredentialsWithTestConnectionRequest, executing DM.EnterpriseGateway Error: 0 : 2016-05-25T21:16:15.6179026Z DM.EnterpriseGateway b5d7687f-6370-468a-a631-f89315aabd1e 0c358dbf-397e-b1aa-b794-30c1cb9f35d0 MGTD 1ddd0949-c6c8-48f5-95de-385ea0662826 57446841 [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToParseUsername: Error parsing username '<pi>●●●●●●●●●●●●</pi>'.; ErrorShortName: FailedToParseUsername DM.EnterpriseGateway Error: 0 : 2016-05-25T21:16:15.6179026Z DM.EnterpriseGateway b5d7687f-6370-468a-a631-f89315aabd1e 0c358dbf-397e-b1aa-b794-30c1cb9f35d0 MGTD 1ddd0949-c6c8-48f5-95de-385ea0662826 11A796ED [DM.Pipeline.Diagnostics] StackTrace: at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToParseUsername.TraceConstructor() at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToParseUsername..ctor(String message, PowerBIErrorDetail[] errorDetails) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.ImpersonateInternal(String userName, String password) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.Impersonate(String userName, String password) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.SqlDbConnectionProvider.<OpenConnectionAsync>d__0.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.SqlDbConnectionProvider.OpenConnectionAsync() at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.SqlDbConnectionProvider.<TestConnectionAsync>d__9.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.SqlDbConnectionProvider.TestConnectionAsync() at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.AdoNetDbFullConnectionString.<TestConnectionAsync>d__9.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.AdoNetDbFullConnectionString.TestConnectionAsync() at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.DbFullConnectionString.<TestConnectionAsync>d__0.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.DbFullConnectionString.TestConnectionAsync(DatabasesRequestBase dbRequestPayload, IGatewayCredentialStore credentialStore) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass28.<<TestDataSourceConnection>b__27>d__2a.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass28.<TestDataSourceConnection>b__27() at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<TestDataSourceConnection>d__2e.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.TestDataSourceConnection(GatewaySerializationContext serverContext, DatabasesRequestBase requestPayload) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass34.<<EncryptCredentialsWithTestDataSourceConnection>b__33>d__36.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass34.<EncryptCredentialsWithTestDataSourceConnection>b__33() at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<EncryptCredentialsWithTestDataSourceConnection>d__42.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.EncryptCredentialsWithTestDataSourceConnection(GatewaySerializationContext responseContext, EncryptCredentialsWithTestConnectionRequest requestPayload) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchImpl>d__e.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.DispatchImpl(GatewaySerializationContext responseContext, OperationRequestBase requestObj) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<Dispatch>d__b.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.Dispatch(GatewaySerializationContext serializationContext, OperationRequestBase requestObj) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<DeserializeImpl>d__e.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.DeserializeImpl(GatewayRelayContext requestContext, GatewaySerializationContext responseContext) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass4.<<Deserialize>b__2>d__6.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass4.<Deserialize>b__2() at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<Deserialize>d__9.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.Deserialize(GatewayRelayContext requestContext) at System.Threading.Tasks.Dataflow.ActionBlock`1.ProcessMessageWithTask(Func`2 action, KeyValuePair`2 messageWithId) at System.Threading.Tasks.Dataflow.ActionBlock`1.<>c__DisplayClass7.<.ctor>b__1(KeyValuePair`2 messageWithId) at System.Threading.Tasks.Dataflow.Internal.TargetCore`1.ProcessMessagesLoopCore() at System.Threading.Tasks.Task.Execute() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot) at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) at System.Threading.ThreadPoolWorkQueue.Dispatch() DM.EnterpriseGateway Error: 0 : 2016-05-25T21:16:15.6179026Z DM.EnterpriseGateway b5d7687f-6370-468a-a631-f89315aabd1e 0c358dbf-397e-b1aa-b794-30c1cb9f35d0 MGTD 1ddd0949-c6c8-48f5-95de-385ea0662826 433AA537 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=1, err=FailedToParseUsername, rootcauseErrorEventId=0) DM.EnterpriseGateway Error: 0 : 2016-05-25T21:16:15.6179026Z DM.EnterpriseGateway dc01e3e1-3ee5-4060-8c53-0fdeff15a16e 0c358dbf-397e-b1aa-b794-30c1cb9f35d0 MGEC 1ddd0949-c6c8-48f5-95de-385ea0662826 4C0C6E59 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=16, err=FailedToParseUsername, rootcauseErrorEventId=0) DM.EnterpriseGateway Error: 0 : 2016-05-25T21:16:15.6179026Z DM.EnterpriseGateway c67306d3-71a9-449e-ac8b-9a300adfa16f 0c358dbf-397e-b1aa-b794-30c1cb9f35d0 MGPP 1ddd0949-c6c8-48f5-95de-385ea0662826 6EFDDBFE [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=17, err=FailedToParseUsername, rootcauseErrorEventId=0) DM.EnterpriseGateway Error: 0 : 2016-05-25T21:16:15.6179026Z DM.EnterpriseGateway 6adb3d1e-91ce-40ea-805f-f34b4174352c 0c358dbf-397e-b1aa-b794-30c1cb9f35d0 MDSR 1ddd0949-c6c8-48f5-95de-385ea0662826 46C25D76 [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToParseUsername: Error parsing username '96AF96247708249FF6A1E825E6EBBB099343977B03FF853D430F70891F5A4C9D'. TemplateMessage: Error parsing username. GatewayPipelineErrorCode=DM_GWPipeline_Gateway_BadUsernameFormat ([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToParseUsername.StackTrace:) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.ImpersonateInternal(String userName, String password) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.Impersonate(String userName, String password) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.SqlDbConnectionProvider.<OpenConnectionAsync>d__0.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.GatewayDataAccess.SqlDbConnectionProvider.<TestConnectionAsync>d__9.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.ConnectionStrings.AdoNetDbFullConnectionString.<TestConnectionAsync>d__9.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.ConnectionStrings.DbFullConnectionString.<TestConnectionAsync>d__0.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__DisplayClass28.<<TestDataSourceConnection>b__27>d__2a.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.<TestDataSourceConnection>d__2e.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__DisplayClass34.<<EncryptCredentialsWithTestDataSourceConnection>b__33>d__36.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.<EncryptCredentialsWithTestDataSourceConnection>d__42.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.GatewayProcessorDispatcher.<DispatchImpl>d__e.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.GatewayProcessorDispatcher.<Dispatch>d__b.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.Serialization.GatewayDeserializer.<DeserializeImpl>d__e.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.Serialization.GatewayDeserializer.<>c__DisplayClass4.<<Deserialize>b__2>d__6.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.Serialization.GatewayDeserializer.<Deserialize>d__9.MoveNext()
Thanks for sharing the logs @Anonymous
Looks like a minor UI bug on our side, as we're not clearing the text fields properly.
When you switch from "Organizational" to "Private" you need to re-type the username and password again. Try it and let me know if that resolves the issue.
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 |
---|---|
100 | |
51 | |
19 | |
12 | |
11 |