Online refresh is failing : Compressed DataSize For Packet Exceeded

[Maysam]

Need Help: Manage storage is showing dataset size is 37 MB and the overall size is 10 GB. but online refresh fails with the following error:

"Data source error: {"error":{"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","pbi.error":{"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","parameters":{},"details":[]}}} Table: AfterSales File Size."

Knowing that the table "AfterSales File Size" is from folder and was working fine before. 

[trisha29]

I was able to resolve the same error by shrinking down my text columns as Power BI supports a maximum of 32766 characters in a column of text data type

[docsapro]

I've got the same error for data source that was working finer before

[Nepal101]

Hello @Maysam and @tryniti84 
Was there any solution for it? I am encountering the same issue. 
Thank you 

[tryniti84]

I solved the problem. The problem in my case was that:

- I imported a complete carpet in Power query. I did it to be able to read from one file the date of creation of specific file in the carpet.  

- When I imported the complete carpet I started to see the dataseize exceed. 

To solve the problem I filtered the chart with the list of the files included in the carpet and I removed thanks to the filter the other files not neeeded. In this way the data size was correct and no problems anymore.

[tumuju]

What is a "complete carpet"?

[tryniti84]

Folder NOT carpet. I mean that I import the complete folder with all files inside. 

[tryniti84]

I have same error of data size but the data set is 20mb.

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","pbi.error":{"code":"DM_GWPipeline_Gateway_CompressedDataSizeForPacketExceededError","parameters":{},"details":[]}}} Table: Attachments.