Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Power BI Gateway Refresh 10GB Limit Failure

Submitted by Anonymous on ‎06-07-2019 06:53 AM

We are loading a dataset that is no larger than 3GB and am able to refresh it and publish from desktop just fine. When the scheduled refresh runs or when we manually kick it off in the Gateway service I get the error below. This error just started this week. The same exact dataset used to refresh  through the gateway service just fine in the past. We actually have larger datasets running just fine on the gateway service.

 

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.
Please try again later or contact support. If you contact support, please provide these details.
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID: 6b0d9695-d1ac-4d01-adb3-8c95243bdd55
Request ID: 908c472a-93e4-4283-9f1d-65c9bfab687c
Time: 2019-06-07 11:47:44Z

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎06-09-2019 07:52 PM

Hi @Anonymous, 

 

As the error message mentioned, you need to reduce the data of the dataset or place the dataset in a premium workspace then do refresh. See: https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios#uncompressed-data-limits-for-refresh

 

Best Regards,
Qiuyun Yu 

Idea Statuses