Forum Discussion
po
Post Prodigy
Post ProdigyUncompressed 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...
GilbertQ
Super User
Super UserHi 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.
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.