Forum Discussion

pauln150's avatar
pauln150
New Member
9 years ago

Enterpise Gateway data refresh failing

Our company has been working to put together a dashboarding and reporting solutions over past couple of months and everything was going great until about two weeks ago when the automatic refresh thru...
General Comment
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi pauln150,

 

What's the error message of this issue? 

 

Best Regards!

Dale

pauln150's avatar
pauln150
New Member
9 years ago

The error is "The received uncompressed data on the gateway client has exceeded limit."  My research shows that the new Premium license now only allows the source data to be 10G, even if the compression is going to make it smaller than the 1 Gig limit.

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi pauln150,

     

    I have tried to find out some official answers and I found it here: powerbi-gateway-onprem-tshoot. And there are some suggestions.

    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.

     

    Maybe you'd better put some of the data in the cloud service, like Azure, if possible.

     

    Best Regards!

    Dale