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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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.