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.

jpsolares

Power BI Gateway - Exced the limit.

Submitted by on ‎08-28-2017 11:38 AM

Hi i having problems with PowerBI - Gateway,

 

I receive the next problem:

  • The received uncompressed data on the gateway client has exceeded limit.

A litle bit of history, is one table with 37 columns with 26.5 millions records but the interesting is 400Mb of size, and is not free accout, is a Pro Account. The data conection mode is "Import".

 

Any direccion o limitations are welcome.

 

Thanks in advance,

 

JP

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-haibl-msft
Employee
Employee
‎08-29-2017 11:06 PM

@jpsolares

 

Data limit here is not related to model size. It is related to how much data is being transferred during refresh. There is a 10 GB limit on that. There is no data download limits in PBI desktop so it will be successful over there.

 

For more information please see https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/ and https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-troubleshooting-refresh-scenarios/...

 

Error: The received uncompressed data on the gateway client has exceeded limit. The exact limitation is 10 GB of uncompressed data per table. If you are hitting this issue, there are good options to optimize and avoid the issue. In particular, 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.

 

The comments provided by Burningsuit in this thread should also be helpful to understand.

 

Best Regards,
Herbert

Idea Statuses