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.

rbruce545

Gateway not Refreshing Datasets

Submitted by on ‎10-08-2019 02:39 AM

Data was refreshing through the gateway but have recently been getting the following error. Please note the dataset being refreshed is 4GB and the only other tables in the report are less than 7KB, 2KB and 18KB - these are all csv files.

 

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. 

 

Thanks

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎10-08-2019 10:29 PM

Hi @rbruce545, 

 

The dataset is highly compressed, but when the dataset is refreshing in Power BI service, the data are uncompressed. In a shared capacity, if uncompressed data size exceeds 10G, the error in your scenario will pop out. 

 

For this kind of issue, we can either reduce the amount of data being imported to Power BI and try again, or assign a premium capacity for the app workspace which contains this dataset. 

 

For more information, see: https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios#uncompressed-dat...

 

Best Regards,
Qiuyun Yu

Idea Statuses