Buenas,
Tengo un Power BI que obtengo los datos por DirectQuery. El acceso al servidor desde la aplicación de escritorio no me da ningún problema y los obtengo con las credenciales de usuario.
Cuando publico y creo la Gateway pongo el mismo servidor y las mismas credenciales de usuario. Cuando la enlazo con el reporte todo parece estar bien pero una vez entro al reporte todas las ventanas me dan error porque no puede acceder a los datos.
Pongo a continuación el inicio del log de errores que me da el Gateway.
Muchas gracias.
DM.EnterpriseGateway Error: 0 : 2023-12-14T10:50:05.9730347Z DM.EnterpriseGateway 0ed368c9-8098-4dfb-ba4e-a17c0c1df6d0 55357e5a-c177-41c2-b8b0-9c3ea416fb0e MGCC 55357e5a-c177-41c2-b8b0-9c3ea416fb0e 916b1573-0def-41c5-92e2-a80ff2f34d49 916b1573-0def-41c5-92e2-a80ff2f34d49 8B21C03B [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToImpersonateUserException: Failed to create windows identity for user <euii>powerbi@wgmsl.com</euii>; ErrorShortName: FailedToImpersonateUserException/Wrapped(SecurityException)[HResult=-2146233078]
DM.EnterpriseGateway Error: 0 : 2023-12-14T10:50:06.0005173Z DM.EnterpriseGateway 0ed368c9-8098-4dfb-ba4e-a17c0c1df6d0 55357e5a-c177-41c2-b8b0-9c3ea416fb0e MGCC 55357e5a-c177-41c2-b8b0-9c3ea416fb0e 916b1573-0def-41c5-92e2-a80ff2f34d49 916b1573-0def-41c5-92e2-a80ff2f34d49 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=37, err=FailedToImpersonateUserException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T10:50:06.0005173Z DM.EnterpriseGateway 143a4754-3611-49b9-85d3-f86aa582d57e 55357e5a-c177-41c2-b8b0-9c3ea416fb0e MGGC 55357e5a-c177-41c2-b8b0-9c3ea416fb0e 916b1573-0def-41c5-92e2-a80ff2f34d49 916b1573-0def-41c5-92e2-a80ff2f34d49 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=38, err=FailedToImpersonateUserException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T10:50:06.0005173Z DM.EnterpriseGateway 9a4c7980-4227-4200-a87c-c629495ac419 55357e5a-c177-41c2-b8b0-9c3ea416fb0e MGOC 55357e5a-c177-41c2-b8b0-9c3ea416fb0e 916b1573-0def-41c5-92e2-a80ff2f34d49 916b1573-0def-41c5-92e2-a80ff2f34d49 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=38, err=FailedToImpersonateUserException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T10:50:06.0005173Z DM.EnterpriseGateway 853c456d-4d80-4788-91b5-5e150aabc49d 55357e5a-c177-41c2-b8b0-9c3ea416fb0e MGPP 55357e5a-c177-41c2-b8b0-9c3ea416fb0e 916b1573-0def-41c5-92e2-a80ff2f34d49 916b1573-0def-41c5-92e2-a80ff2f34d49 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=38, err=FailedToImpersonateUserException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T10:50:06.0015166Z DM.EnterpriseGateway ee8d714e-cad0-4799-a43a-9b7018f349e9 55357e5a-c177-41c2-b8b0-9c3ea416fb0e MDSR 55357e5a-c177-41c2-b8b0-9c3ea416fb0e 916b1573-0def-41c5-92e2-a80ff2f34d49 916b1573-0def-41c5-92e2-a80ff2f34d49 4C1EF73E [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.FailedToImpersonateUserException: Failed to create windows identity for user <euii>powerbi@wgmsl.com</euii>
TemplateMessage: Error impersonating a user.
GatewayPipelineErrorCode=DM_GWPipeline_Gateway_ImpersonationError
GatewayVersion= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: SecurityException:<ccon>The name provided is not a properly formed account name.
</ccon>
GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=SecurityException
InnerMessage=<ccon>The name provided is not a properly formed account name.
</ccon>
InnerToString=<ccon>System.Security.SecurityException: The name provided is not a properly formed account name.
