Forum Discussion
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 uncompressed file size limit exceeded
Error: The received uncompressed data on the gateway client has exceeded the limit.
The exact limitation is 10 GB of uncompressed data per table.
Why woud be ge getting this message for the table when cleraly way under 10GB?
Thanks
11 Replies
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.
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
- Hi there
I have not had that error in the past.
Could you try the incremental refreshing?
- Hi there
There are quite a few things that could be causing this.
One question I would ask is are you creating any tables or calculated columns using DAX?
The reason for this is because this data would not be compressed before sending it via the Power BI Gateway.
Also if possible to use incremental refresh on your fact table?
This will reduce the amount of rows required which will also decrease the memory size and data size.
