Showing results for 
Search instead for 
Did you mean: 

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 Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

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!

Top Solution Authors