Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, we have developed powerbi report in powerbi desktop, with import connectivity mode, refresh works in powerbi desktop. But then when we publish it to powerbi portal, assigning appropriate data gateway, we get following errors:
M.EnterpriseGateway Error: 0 : 2017-11-01T14:59:24.3368072Z DM.EnterpriseGateway 9c13c13f-fb86-4123-a0a3-2130fe7aecd4 4f257845-4789-4fc3-4b47-76350cf4c944 MGCC f11f5398-ed74-44f8-a27c-88f551700923 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.<b__0>d.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionPool.<>c__DisplayClass1_0.b__0() at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.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.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.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.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.<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.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 Error: 0 : 2017-11-01T14:59:24.3368072Z DM.EnterpriseGateway c365b3d5-3069-4a2a-aa1c-cde310778b0e 4f257845-4789-4fc3-4b47-76350cf4c944 MGCC f11f5398-ed74-44f8-a27c-88f551700923 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.<b__0>d.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionPool.<>c__DisplayClass1_0.b__0() at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.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.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.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.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.<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.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 Error: 0 : 2017-11-01T14:59:24.3368072Z DM.EnterpriseGateway 5db5d465-87fe-4bd4-9d26-f11ec05bccc1 4f257845-4789-4fc3-4b47-76350cf4c944 MGCC f11f5398-ed74-44f8-a27c-88f551700923 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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.