Power Bi On Premise Gateway connection issues

[alexb11]

Hello,

we have a PC dedicated to reporting and hosting our On Premise Gateway for Power BI. However it keeps signing my user out automatically for some reason. And he has to keep going in and resigning into the app. 

Could someone help me here? Here is a log i took for this around the time of the most recent issue:

Log File Retention Type: File count based retention
Log File Count: 20
Log File Set Total Size: 52428800

DM.PersonalGateway Critical: 0 : 2023-10-31T01:36:24.3862274Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 02A788E9 [DM.EventSourceHosting] Unable to start ETW session. Please
1. run `net localgroup "Performance Log Users" /add "POWER\corbin.nelson"` to grant ETW logging permissions to the gateway user.
2. restart the gateway

Full exception: System.UnauthorizedAccessException: Error Starting ETW: Access Denied (Administrator rights required to start ETW)
at Microsoft.Diagnostics.Tracing.Session.TraceEventSession.EnsureStarted(EVENT_TRACE_PROPERTIES* properties)
at Microsoft.Diagnostics.Tracing.Session.TraceEventSession.EnableProvider(Guid providerGuid, TraceEventLevel providerLevel, UInt64 matchAnyKeywords, TraceEventProviderOptions options)
at Microsoft.PowerBI.DataMovement.Pipeline.EventSourceListener.MashupTraceEventWriter..ctor(Stream stream, Func`1 rotate, String sessionNamePostfix)
at Microsoft.PowerBI.DataMovement.Pipeline.EventSourceHosting.EventSourceHost.<>c__DisplayClass6_0.<StartCollectingEvents>b__1()
at Microsoft.PowerBI.DataMovement.Pipeline.EventSourceHosting.EventSourceHost.ConstructTraceEventWriterWithErrorHandling(Action action)

Starting trace on 10/31/2023 10:36:46 PM UTC
UserDomainName: POWER
UserName: corbin.nelson
MachineName: NPFUS045
Log File Retention Type: File count based retention
Log File Count: 20
Log File Set Total Size: 52428800

DM.PersonalGateway Critical: 0 : 2023-10-31T22:36:46.4817892Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 02A788E9 [DM.EventSourceHosting] Unable to start ETW session. Please
1. run `net localgroup "Performance Log Users" /add "POWER\corbin.nelson"` to grant ETW logging permissions to the gateway user.
2. restart the gateway

Full exception: System.UnauthorizedAccessException: Error Starting ETW: Access Denied (Administrator rights required to start ETW)
at Microsoft.Diagnostics.Tracing.Session.TraceEventSession.EnsureStarted(EVENT_TRACE_PROPERTIES* properties)
at Microsoft.Diagnostics.Tracing.Session.TraceEventSession.EnableProvider(Guid providerGuid, TraceEventLevel providerLevel, UInt64 matchAnyKeywords, TraceEventProviderOptions options)
at Microsoft.PowerBI.DataMovement.Pipeline.EventSourceListener.MashupTraceEventWriter..ctor(Stream stream, Func`1 rotate, String sessionNamePostfix)
at Microsoft.PowerBI.DataMovement.Pipeline.EventSourceHosting.EventSourceHost.<>c__DisplayClass6_0.<StartCollectingEvents>b__1()
at Microsoft.PowerBI.DataMovement.Pipeline.EventSourceHosting.EventSourceHost.ConstructTraceEventWriterWithErrorHandling(Action action)

[lbendlin]

1. Don't use a Personal Gateway.  Procure a VM (better two or more) that are online 24x7 and install Enterprise Gateway.

2. Don't mess with the logins.  Use the standard service account and leave it alone.  Nobody needs to be logged in for the gateway service to run.

[alexb11]

Howdy.

Thanks for that info! Quick question, do you know if the "Refresh A Dataset" action in power automate would replace the need for an on premise gateway? just exploring my options!

Thanks!

[lbendlin]

no, it will not.  Gateways are required for all on-premise data sources (and cloud data sources if you make the unfortunate choice to try and merge them in any way)