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

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.

Reply
Anonymous
Not applicable

Enterprise Gateway Stopped Working

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.

 

Gateway.png

 

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

Gateway1.png

 

Re-saving fails

Gateway2.png

 

3 REPLIES 3
dimazaid
Employee
Employee

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

Anonymous
Not applicable

@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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors