Forum Discussion
Uncompressed size limit execeeded error message despite uncompressed table being appprox 3GB
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.
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?
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
- Hi there
The size on disk is the compressed size.
A rough estimate is that the memory requirement is roughly 3-4x this size on disk, which would push it over 10GB
Can you please run the DAX Studio View Metrics and post the output here for us to assist?
