Forum Discussion
po
Post Prodigy
Post ProdigyUncompressed size limit execeeded error message despite uncompressed table being appprox 3GB
Hi, Have a pbix file approx 450 MB and can refresh in desktop fine 40 million rows 2.7GB fact table and other tables fairly small. Get error message when try refresh via gateway saying uncomp...
poPost Prodigy
Post ProdigyThanks 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
GilbertQ
Super User
Super UserHi 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?
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?