Forum Discussion

po's avatar
po
Post Prodigy
6 years ago

Uncompressed 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...
Need Help
po's avatar
po
Post Prodigy
6 years ago

Thanks for suggestion -  enough cpu/ram when ran last time looked at whilst running - 8gb ram

  • po's avatar
    po
    Post Prodigy
    6 years ago

    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

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    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?
  • po's avatar
    po
    Post Prodigy
    6 years ago

    Hi,

     

    Thanks for reply.

     

    This is uncompressed size on disk of the data before hits power bi - oracle storing the data and 2.7gb on disk uncompressed.

     

    Thus expecting it to easily fot within the 10GB power bi limit but somehow doesn't

     

    Thanks