Forum Discussion

Maysam's avatar
Maysam
Regular Visitor
3 years ago

Online refresh is failing : Compressed DataSize For Packet Exceeded

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_Gatew...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

We had the same issue; we had pulled all files in a folder into Power Query to obtain the latest file date (for display in PBI).

- The Compressed data Size condition (error) did not occur within the desktop verion when we refreshed there

- The Compressed data Size condition (error) did not occur within Power Query when we refreshed there.

- The Compressed data Size condition (error) did occur when a refresh was processed on the Power BI service (Premium) 

As was suggested above, we simply used Remove Columns for all colums not used for the latest file date output.  We also used a DESC Sort to get the latest date and then used a  Keep Top Rows (=1) to return the latest date.  

The Remove Columns, it seems, reduced the length of row size enough to eliminate the  Compressed data Size condition when a refresh was processed by the Power BI (Fabric...whatever the name is today) service.