Forum Discussion
Post ProdigyUncompressed size limit execeeded error message despite uncompressed table being appprox 3GB
Post ProdigyThanks for suggestion. However, incremental refresh not appropriate here.
po I was re-reading this and it almost sounds like the issue could be on the server/machine that hosts the gateway and not necessarily the Service. Do you have enough RAM on the machine hosting the gateway to process and push the data to the Service? Might help to monitor that machine while you are initiating a refresh.
- po
Thanks for suggestion - enough cpu/ram when ran last time looked at whilst running - 8gb ram
po Its still likely what the error is explicitly pointing out. The uncompressed data is a lot larger than you think. See similiar thread here -> https://community.powerbi.com/t5/Service/The-amount-of-uncompressed-data-on-the-gateway-client-exceeded/td-p/466792
Have you tried any methods to reduce the size of the model? Remove any columns that are not needed, etc?
- po
Thanks for reply.
The table is a fact table with not very manu columns, no calculated columns, no strings and all numeric values - fully optimised.
As the docuemnation states The amount of uncompressed data on the gateway client has exceeded the limit of 10 GB for a single table
The size of the table on disk is 2.7 GB and and even ran with no visuals and also used the power bi gateway performance report and shows spooled disk size (assume this column) alos other columns number of byeses not near 10GB hence unlcear why get this error.
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance