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

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.

      • 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