cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chlisa01 Frequent Visitor
Frequent Visitor

can't refresh dataset

I have created a report which import data from a table of a MS SQL server via the Data Gateway and I have scheduled on a daily basis the refresh. Everything worked fine, but since July when I am trying to run the refresh of the data I am receiving  the  error message "The received uncompressed data on the gateway client has exceeded limit.".  If I try to publish the same report from Power BI Desktop there is not an issue, everything works fine.

Looking at the site I found that there is a limitation of 10 GB uncompressed data which you can refresh through gateway but my table in SQL is approximately 6 GB.

Could you please inform me why this is happening?

3 REPLIES 3
Community Support Team
Community Support Team

Re: can't refresh dataset

Hi @chlisa01,

 

Please check below link to know more about this issue.

 

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. Users model can be 488 MB but if he is downloading more than 10 GB during refresh it will fail. Please provide RAID's if you want us to investigate new refresh failures. 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/

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.

 

Gateway limitations

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
chlisa01 Frequent Visitor
Frequent Visitor

Re: can't refresh dataset

Dear Xiaoxin,

 

The data that I try to refresh via the gateway is almost 9 GB. So i can't understand why it is failed as the limitation is 10 GB.

 

Regards,  

 

Agelow

Community Support Team
Community Support Team

Re: can't refresh dataset

Hi @chlisa01,

 

>>The data that I try to refresh via the gateway is almost 9 GB. So i can't understand why it is failed as the limitation is 10 GB.

I'm also not very sure for this, perhaps you can try to contact power bi team for further support.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)