Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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.
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?
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:
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
101 | |
98 | |
97 | |
38 | |
37 |
User | Count |
---|---|
152 | |
121 | |
73 | |
71 | |
63 |