Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Scheduled Refresh failure even after Incremental Refresh

Hi Everyone, wanted to know about if anyone ever faced an issue with scheduled refresh setup on a dataset, even though the partitions are created and verified using XMLA endpoints. We have setup the incremental refresh on 2 fact tables, each having close to 1.5 million rows in total. Out of this, 2 years data, worth ~800k rows is archived and only recent 3 days data is setup for refresh. Could it be advised if increasing the capacity can resolve this, or is there a better way to resolve this? Below is the error received. Thanks.

 

Resource Governing: This operation was canceled because there wasn’t enough memory to finish running it. Either reduce the memory footprint of your dataset by doing things such as limiting the amount of imported data, or if using Power BI Premium, increase the memory of the Premium capacity where this dataset is hosted. More details: consumed memory 2229 MB, memory limit 2227 MB, database size before command execution 844 MB

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. Before thinking about increasing the capacity you should always check some practices.

First of all, be aware of the data model. Creating a good star schema of the process you are solving at the model it's important. Then read the following doc with practices.

https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

If any of those reduce the size of the model or the time of the refresh. Then you can consider upgrading your capacity.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

View solution in original post

1 REPLY 1
ibarrau
Super User
Super User

Hi. Before thinking about increasing the capacity you should always check some practices.

First of all, be aware of the data model. Creating a good star schema of the process you are solving at the model it's important. Then read the following doc with practices.

https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

If any of those reduce the size of the model or the time of the refresh. Then you can consider upgrading your capacity.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.