Data Flow Refresh Failure

[Nissy]

Hi need help in fixing this below issue. Can someone please explain me what this error means?

I have used dataflow and extracted from the same table with 3days data and data pull is done. When im are extracting 2years data from the same table. It's giving the below issue.

Error: Encountered user gateway exception: '[GatewayPipelineErrorCode]=DM_GWPipeline_Client_GatewayUnreachable [ErrorShortName]=GatewayUnreachableException/CommunicationObjectFaultedException[HResult=-2146233087] [ExceptionErrorShortName]=GatewayUnreachableException'. RootActivityId = 0d0fddc1-8687-43de-adff-1f4666b99f0a.Param1 = [GatewayPipelineErrorCode]=DM_GWPipeline_Client_GatewayUnreachable [ErrorShortName]=GatewayUnreachableException/CommunicationObjectFaultedException[HResult=-2146233087] [ExceptionErrorShortName]=GatewayUnreachableException Request ID: d75594df-9435-c0dc-b829-af4358d14a5a.

[kmspsu93]

Hello...we are experiencing the same error sporadically over the course of a year and cycling the VPN associated with the gateway resolves  but not permanantly.  Have you resolved the issue and what specific action was taken?  Thank you!

[v-luwang-msft]

Hi @Nissy ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[lbendlin · Accepted solution]

You seem to have random network instability that is sometimes interrupting the communication between you gateway cluster members and the Power BI Service. Or you have a misbehaving gateway cluster member which will cause the failure when it is randomly chosen by the service to perform the refresh.