Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
oakfootballclub
Helper IV
Helper IV

gateway client has exceeded the limit for a single table

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

5 REPLIES 5
v-kaiyue-msft
Community Support
Community Support

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
Helper IV
Helper IV

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
Super User
Super User

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.

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:

oakfootballclub_0-1726034035856.png

 

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.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.