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.


Doubts about auto-update failure and related topics

Hello colleagues

I scheduled the update of the Dashboards I created and it threw me this information:


I have the idea that it is because of the amount of data that is trying to update and indeed the data that I provide the IT team has 21 million records so it is very heavy, doubt:

1. In Power Query remove columns and filter the information of this data service that I was provided, but , still continues to update me 21 million records although in Power BI the changes are reflected Am I doing something halfway? Is there a way to lower the amount of data and weight, without having to resort to the IT team?

Thank you very much for your support

Community Support
Community Support

Hi, @Syndicate_Admin 

According to your screenshot error, you can see that the amount of data in the datset reaches 10GB when you refresh, which exceeds the limit of the shared capacity.
The first way to solve this problem is to try to reduce the data and model size of your data source, or limit your imported data.

For how to reduce your Power BI data model size, you can refer to :
Top 5 tips to reduce your Power BI data model size — Apex Insights: Power BI tips & tricks

How to reduce your Power BI model size by 90%! | by Nikola Ilic | Towards Data Science


The second is to see if your data source supports Direct Query connections, which are used to connect directly to the data source without importing data into our dataset, so that the 10GB limit is not exceeded.

For more information, you can refer to :
DirectQuery in Power BI - Power BI | Microsoft Learn


The last method is to purchase Premium capacity to meet your needs, which is much larger than 10GB.

For more information, you can refer to :
Pricing & Product Comparison | Microsoft Power BI


Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 


Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

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.

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