The 10GB uncompressed data gateway limitation

[Anonymous]

I am confused.

The amount of uncompressed data on the gateway client has exceeded the limit of 10 GB for a single table. Please consider reducing the use of highly repetitive strings values through normalized keys, removing unused columns, or upgrading to Power BI Premium.
Please try again later or contact support. If you contact support, please provide these details.

I checked the tables in SQl Server Management Studio. The biggest table has a total storage of 8GB, but i am only querying a fraction. The final local compressed pbix is 561mb.

This seems very odd. How can I investigate this further? There is no information in the error message hinting what table i might be.

[v-yuezhe-msft]

@Anonymous,

Do you import all columns of the big table to Power BI Desktop and do you have multiple calculations in the PBIX file? 

The above error message indicates that the uncrompressed data size exceeded the 10GB limitation at the time of reading the data during the refresh process, reducing the use of highly constant, long string values and instead using a normalized key or removing the column (if not in use) will help.

There are some discussions in the similar threads below for your reference.

https://community.powerbi.com/t5/Service/The-received-uncompressed-data-on-the-gateway-client-has/td-p/194153/page/2
https://community.powerbi.com/t5/Issues/Knowing-the-uncompressed-dataset-size-on-the-gateway/idi-p/192450/page/2#comments 

Regards,
Lydia

[Anonymous · Accepted solution]

It is a fact table with mainly numeric data. I did convert a couple of columns of small strings to numeric values but it did not help.

Finally I had som success by reducing the amount of rows imported.

I suspect the data gets quite bloated in the import process, or maybe there still is a limit on the number of rows allowed. 10GB seems like a lot of data when comparing how much data the actual table stores on disk. I wish the process was more transparent so that I didn't have to guess what is happening.