cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Dataflow to on-prem SQL Server results Something went wrong.

We are trying to use dataflow to load CDS with on-prem data. We are able to successfully connect to the on-prem SQL Server, see all the views and tables and able to select and move to the transform Data screen. After completing the configuration when the prompt reaches Executing the Load stage, after a long pause it results on the below error.

 

Something went wrong. (Job ID: 5f17fe1f-7cab-4d8f-a0bb-7aa79678d11c)

 

The Error on the gateway says.

 

DM.EnterpriseGateway Error: 0 : 2020-02-05T11:19:23.0743938Z DM.EnterpriseGateway b164bcd0-9301-4b60-8558-36c3d59b9861 e3e8d2b6-c756-4418-8892-b908645d4091 MGEA d4a7706e-05f4-4a48-a4c0-1503875886ec 3658d306-852a-49eb-bd76-d8c57ded46dc a08bc568-6d8d-4819-98a1-ce06aef0fea7 BE264D11 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupValueException (0x80004005): AzureBlobs failed to get the response: 'Unable to connect to the remote server'.
at Microsoft.Data.Mashup.ProviderCommon.MashupResource.<>c__DisplayClass44_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()

 

Please help.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

HI @PratikParab ,

 

In these types of errors our suggestion would be to raise a Support Request with Microsoft, so we can perform a more in depth Troubleshooting to understand exactly what is going on with the issue you are currently facing.

 

The support request can be opened from your admin portal: https://admin.powerplatform.microsoft.com/support

 

 

Hope this helps!

 

Regards,

Ricardo

View solution in original post

1 REPLY 1
Microsoft
Microsoft

HI @PratikParab ,

 

In these types of errors our suggestion would be to raise a Support Request with Microsoft, so we can perform a more in depth Troubleshooting to understand exactly what is going on with the issue you are currently facing.

 

The support request can be opened from your admin portal: https://admin.powerplatform.microsoft.com/support

 

 

Hope this helps!

 

Regards,

Ricardo

View solution in original post

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (3,725)