Need help to determine uncompressed data size

[kdyess1]

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

[v-haibl-msft]

@kdyess1

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/...
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