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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors