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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
syam_v
Frequent Visitor

The gateway operation has been cancelled explicitly by the user or from a timeout.

DM.EnterpriseGateway Error: 0 : 2017-12-11T07:47:29.8257581Z DM.EnterpriseGateway 7133f834-68cb-475d-acd7-fa391faf1a64 96cb5044-f444-3195-dfd2-b64e8e9b15eb MGCC df783daa-349b-8640-0a53-d3b2d41a9d30 36D40354 [DM.Pipeline.Diagnostics] StackTrace: at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException.TraceConstructor()
at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException..ctor(String extensionKind, String message, PowerBIErrorDetail[] errorDetails)
at Microsoft.PowerBI.DataMovement.MashupExtensionsDiscovery.MashupExtensionsManager.IsExtensionDQSupported(String extensionKind, String version)
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.IsDataSourceDQSupported(DbConnection dbConnection)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionPool.<>c__DisplayClass1_0.<<CreateObjectInstance>b__0>d.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionPool.<>c__DisplayClass1_0.<CreateObjectInstance>b__0()
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__7`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.AdoNetDbConnectionPool.<CreateObjectInstance>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionPool.CreateObjectInstance(AdoNetDbFullConnectionString key)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.BasePool`3.<CreatePoolObject>d__24.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.BasePool`3.CreatePoolObject(TPoolObjectKey poolKey, TObjectKey objectKey)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.StatelessPool`2.<ProactivePoolingCreation>d__16.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.StatelessPool`2.ProactivePoolingCreation(Object stateInfo)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.StatelessPool`2.<>c__DisplayClass11_0.<<StartProactivePoolCreation>b__0>d.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.StatelessPool`2.<>c__DisplayClass11_0.<StartProactivePoolCreation>b__0()
at System.Threading.Tasks.Task`1.InnerInvoke()
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 Warning: 0 : 2017-12-11T07:47:29.8257581Z DM.EnterpriseGateway 7133f834-68cb-475d-acd7-fa391faf1a64 96cb5044-f444-3195-dfd2-b64e8e9b15eb MGCC df783daa-349b-8640-0a53-d3b2d41a9d30 359963D8 [DataMovement.PipeLine.MashupCommon] Failed to find referenced data sources. Exception: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException: Mashup extension kind is not loaded
TemplateMessage: Mashup extension SQL does not load into Mashup Engine

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
ExtensionKind=SQL
([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException.StackTrace:)
at Microsoft.PowerBI.DataMovement.MashupExtensionsDiscovery.MashupExtensionsManager.IsExtensionDQSupported(String extensionKind, String version)
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.IsDataSourceDQSupported(DbConnection dbConnection)

8 REPLIES 8
v-yuezhe-msft
Employee
Employee

@syam_v,

Are you able to refresh the dataset in Power BI Desktop? If there is no issue refreshing it in Desktop, please install the latest version of Power BI on-premises gateway, then check if you get errors.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I am able to refresh on PowerBI desktop. Only issue is with on demand/scheduled refresh from PowerBI service. I am using onpremise enterprise gateway edition. Do I really need to install latest version? is it the only option?

@syam_v,

The issue has been submitted internally, and PG'response is as follows. Please install the latest version of on-premises gatewway and check the issue.

Ih the November release we resolved an issue that has affected a small set of customers who have multiple datasets refreshing at the same time and in which some refreshes fail with timeout error because gateway was busy with other refreshes.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft,

 

Let me try this option of installing latest gateway and see this resolves the refresh from PowerBI service problem or not.

syam_v
Frequent Visitor

I updated existing gateway with new update, that also failed. Later, I set up new gateway altogther on brand new server. It also did not work out. Still having the same issue. Any help is appreciated.

@syam_v,

The error only occurs for the specific dataset, right? Please create a small report with limited rows using the SQL data source and check if the refresh works in Power BI Service.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

It's for all datasets. I tested only one table in the powerbi model. Even that also failed. I did this test long back before installing new gateway and all this stuff.

@syam_v,

Please open a support ticket on the support.powerbi.com site.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors