502 Error: Unexpected Exception Max Packet Limit Reached

[doubles]

I have a Flow that takes a JSON array created from data in Power BI and inserts that data into SQL using OPENJSON (via a PowerApp; using an on premises gateway). So the flow passes the JSON string as a variable into the stored proc. When I get particularly large data sets, the flow fails, returning a 502 error with the message: ""message": "Unexpected Exception : [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayClientMaxPacketLimitReachedException: packet reached the maximum limit = '4' at gateway client." It retries the exec 4 times, so my data ends up being inserted 5 times. I was wondering if anyone is aware of a workaround for this -- the data is getting inserted, so I'm not sure why an error is being thrown.

Thank you for any help.

[v-alzhan-msft]

Hi @doubles ,

Could you please share a screenshot of the configuration of your flow?

Have you take a try to run the flow again? If the error code 500 or 502 appears, the failure is temporary or transient, please click or tap Resubmit to try the flow again to see if the issue still exists.

Best regards,

Alice       

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

[doubles]

@v-alzhan-msft 

Hi Alice,

Thank you for your reply. This has been happening everytime the json string is large enough to not display in the flow dialogue. So it has been resubmitted many times, it just doesn't work when the string is a certain size, it seems.