Scheduled Refresh failure even after Incremental Refresh

[Anonymous]

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

[ibarrau · Accepted solution]

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,