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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

po Are you referencing the source fact table multiple times in any of your Queries in Power Query? Is there something in that process that would explode the data size prior to loading it into the compressed model?

Also, there should be more specific error messages in the log files on the gateway - maybe a peak there would help determine what in particular is causing the out of memory exception.

  • po's avatar
    po
    Post Prodigy
    6 years ago

    Hi,

     

    Thanks for reply.

     

    Not using calculated columns - no fancy power query not referenced multile times.

     

    Simple import of table joined to other tables via manage relationships on join keys sales table e.g linked to products.

     

    Looked at logs and power bi gateway template report - nothing obvious spooled bytes way less than 10GB.

     

    Could you please advise specificially what in logs to look for?

     

    Thanks

    • GilbertQ's avatar
      GilbertQ
      Super User
      6 years ago
      Hi there

      I have not had that error in the past.

      Could you try the incremental refreshing?
      • po's avatar
        po
        Post Prodigy
        6 years ago

        Thanks for suggestion.  However, incremental refresh not appropriate here.