Forum Discussion

krajay007's avatar
krajay007
New Member
2 years ago

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

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

2 Replies

  • Hi Team,

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.