Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Power BI Desktop Model refresh error

Hello Community,


Good evening!

I get the following error message when i try to publish my datamodel in PowerBI desktop.



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 string values through normalised keys,removing unused columns ,upgrading to Power BI premium


I use import mode to load the view in my Power BI desktop.

Following are the table size as example 


PowerBI Login Table : 7012288KB

fact 1 :3783384 KB

fact2 : 227016 KB


I have a few other fact table and dimension with less data.


I tried to calculate the total size of my current data and it is approximately 17 GB

I have PowerBI Pro licence.


Is that the only way is to upgrade to Premium licence or let me know if there is an alternate way?


Thanks in advance





Community Support
Community Support

Hi @Anonymous ,


If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!


Best regards,

Dina Ye

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
Community Support
Community Support

Hi @Anonymous 


The maximum size for datasets imported into the Power BI service is 1 GB. These datasets are heavily compressed to ensure high performance. In addition, in shared capacity, the service places a limit on the amount of uncompressed data that is processed during refresh to 10 GB. This limit accounts for the compression, and therefore is much higher than 1 GB.


Datasets in Power BI Premium are not subject to this limit. If refresh in the Power BI service fails for this reason, please reduce the amount of data being imported to Power BI and try again.


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 constant, long string values and instead using a normalized key or removing the column (if not in use) helps.


More details please refer to: service-gateway-onprem-tshoot#error-the-received-uncompressed-data-on-the-gateway-client-has-exceede... and refresh-troubleshooting-refresh-scenarios#uncompressed-data-limits-for-refresh.


Best regards,

Dina Ye

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors