gateway client has exceeded the limit for a single table

[oakfootballclub]

do anyone know how to solve this issue? what caused this?

is this because the server establish gateway has too few memory? the pbix file is only 200mb, far less that the 1gb

[Anonymous]

Hi @oakfootballclub ,

For Error: The uncompressed data received on the gateway client has exceeded the limit. The exact limit is 10 GB of uncompressed data per table. If you are experiencing this problem, there are good options to optimize and avoid it. In particular, reduce the use of highly constant long string values and use normalized keys instead. Alternatively, if the column is unused, removing it may help.
Details can be found in the documentation: Troubleshoot gateways - Power BI | Microsoft Learn

and you can follow the tips to optimize your report：

1.Do not expose in a view a column that is not necessary in the Power BI data model.

2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.

3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. )

Here are some solutions to problems similar to yours that I hope will help you.

Solved: Premium account : The amount of data on the gatewa... - Microsoft Fabric Community

Solved: data refresh exceeded limit for a single table - Microsoft Fabric Community

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[oakfootballclub]

does anyone know how to solve this issue, what caused this? 

I don't know if it was the performance of server which estabish the gateway is too low.

is this because the server establish gateway has too few memory?

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck? Please show the exact error message.

[oakfootballclub]

what I want to do is to successfully refresh the data, the pbix file is less thant 1 gb, and when I refresh the data, here is the fault:

[lbendlin]

The file size doesn't matter. It's the uncompressed table size that matters. In Premium the limit is 10GB per partition, not per table.