Forum Discussion
Need help to determine uncompressed data size
How do I determine "uncompressed" data size?
Getting the error message:
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.
| Cluster URI: | WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net |
| Activity ID: | c23005ae-e4c2-f142-7ddf-5ca324a027e9 |
| Request ID: | 5cacd23b-b561-9077-32af-bbfe0e0f05fd |
| Time: | 2017-10-05 17:28:36Z |
1 Reply
AFAIK, we cannot determine the uncompressed data size, because the refresh request is terminated as soon as the user downloads more than 10 GB of data from their data source in PBI service. So the only thing we're aware is that the uncompressed data size is larger than 10 GB.
To make the refresh works again, reducing the use of highly repetitive, long string values and instead using a normalized key or removing the column (if not in use) will help.
References:
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-troubleshooting-refresh-scenarios/#uncompressed-data-limits-for-refresh
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/#datasets (Error: The received uncompressed data on the gateway client has exceeded limit)Best Regards,
Herbert
