The amount of uncompressed data on the gateway client has exceeded the limit of 10 GB for a single t

[Nimai123]

 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.

I tried reducing the columns from report making it as small as possible but still having the same issue!

Can anyone help me out here!

[V-lianl-msft]

Hi @Nimai123 ,

Refer to these to reduce size of the PBIX and improve performance of report:

https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques 

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction 

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

see if you have rows that you don't need in your report, like very old data

Otherwise you have to pass to premium

[Nimai123]

There is no point in going to premium just for the schedule refresh issue!

All my data is of the past month, I don't have any old data!

Thanks.

[aj1973]

All data from past month!

Do you use pictures and videos in your dataset, long strings that need to be replaced by shorter keys, complicated DAX calulations, tables that are not necessary...? Did you do some cleaning and transformations to your dataset?

I agree no need to go premium but something ain't right when the client exceeds the limit 10 GB for a month old data.

[Nimai123]

I report is very simple which just has one page with a table visual with no videos just a normal image of clients company and not even DAX or Calculated Column, I just extracted some columns in Power Query from date column which was in text format to get some values out of it like year and month which was also in text format.

There is 33,616,804 rows in my file.

I can't create an aggregation table as I am just displaying my data normally in a table format.

Thanks!

@aj1973 

@V-lianl-msft