Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Help me please! When I tried refresh the dataset on service gateway gets an error like this. I'm going crazy.
DM.EnterpriseGateway Error: 0 : 2020-08-19T08:59:06.7941833Z DM.EnterpriseGateway 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 25E31978 [DM.Analytics] Performance counters not installed, application performance metrics will not be traced (category = Microsoft Power BI Enterprise Gateway)
DM.EnterpriseGateway Error: 0 : 2020-08-19T11:44:13.6333843Z DM.EnterpriseGateway 3d9c3f72-bfa9-45e1-8002-54319517640a bbc9e5f7-38ce-437e-9c1a-88d8f641af38 MGEA 7a3a2a24-ecfa-4a30-9a48-47fe3b80e4ca c713068c-ed1b-4657-9644-20cdd2063b34 c713068c-ed1b-4657-9644-20cdd2063b34 504FB81A [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupHostingException (0x80004005): Timeout expired. The timeout period elapsed prior to completion of the operation.
at Microsoft.Data.Mashup.ProviderCommon.MashupResource.<>c__DisplayClass45_2`1.<StartEvaluationAndGetResultSource>b__0()
at Microsoft.Mashup.Security.Impersonation.RunAsProcessUser[T](Func`1 func)
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.GatewayCore.GatewayProcessorUtils.MashupExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest, Guid activityId)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass3_3.<<ExecuteAdoQuery>b__2>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
DM.EnterpriseGateway Error: 0 : 2020-08-19T11:44:13.6333843Z DM.EnterpriseGateway b9cea8db-abc3-44ae-a2c5-822137fe6f45 bbc9e5f7-38ce-437e-9c1a-88d8f641af38 MGEA 7a3a2a24-ecfa-4a30-9a48-47fe3b80e4ca 2a28b37e-1e34-4bcf-8910-22537bd14570 2a28b37e-1e34-4bcf-8910-22537bd14570 504FB81A [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupHostingException (0x80004005): Timeout expired. The timeout period elapsed prior to completion of the operation.
at Microsoft.Data.Mashup.ProviderCommon.MashupResource.<>c__DisplayClass45_2`1.<StartEvaluationAndGetResultSource>b__0()
at Microsoft.Mashup.Security.Impersonation.RunAsProcessUser[T](Func`1 func)
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.GatewayCore.GatewayProcessorUtils.MashupExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest, Guid activityId)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass3_3.<<ExecuteAdoQuery>b__2>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
Hi , @BirhanAYDS
You can download the file then refresh it on the powerbi desktop to check whether data source is performing norminally.
In addition, you can also use Performance Analyzer to examine report element performance.
Best Regards,
Community Support Team _ Eason
Get a better network?
Joking aside - can you identify the data source that is causing thise error, and can you confirm that that data source is performing nominally? Most of the time this error points to performance issues at the data source.