cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PratikParab
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
rimatos
Community Support
Community Support

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
rimatos
Community Support
Community Support

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (915)