Power Bi Dataflow Error: PipelineException: With compression algorithm the compressed data size in

[krajay007]

Hi All,

Getting below error when trying to fetch data from AWS RDS(Postgresql) to my Dataflow Refresh.

Power Bi Dataflow Error: PipelineException: With compression algorithm the compressed data size in a packet exceeds the max ServiceBus limit: GatewayCompressor - CompressedDataSize (9567748) of a non-compressed packet exceeds the maximum payload size of 8500000 . RootActivityId = ed3b5072-cb0f-4611-9aa6-68ba19a61158.Param1 = PipelineException: With compression algorithm the compressed data size in a packet exceeds the max ServiceBus limit: GatewayCompressor - CompressedDataSize (9567748) of a non-compressed packet exceeds the maximum payload size of 8500000

[krajay007]

Hi Team,

I have already in Workspace premium capacity, Please can you advise how i can increase Payload.

[Anonymous]

Hi @krajay007 ,

This error occurs when the compressed data size in a packet exceeds the maximum payload size of 8500000. To resolve this issue, you can try the following:

1. Reduce the amount of data being fetched from AWS RDS(Postgresql) to your Dataflow Refresh.
2. Split the data into smaller chunks and fetch them separately.
3. Increase the maximum payload size of 8500000.

PipelineException when running dataflow. Compresse... - Microsoft Fabric Community

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.