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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Jaskirat_Kalsi
New Member

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors