Resource Governing Refresh Error

[oliverblane]

I have a dataset that is set to schedule refresh, but it keeps failing with the following error:

Resource Governing: This operation was canceled because there wasn’t enough memory to finish running it.
Either increase the memory of the Premium capacity where this dataset is hosted
or reduce the memory footprint of your dataset by doing things like limiting the amount of imported data.
More details: consumed memory MB, memory limit MB, database size before command execution MB.
Learn more, see https://go.microsoft.com/fwlink/?linkid=2159753.

I have limited the amount of imported data as much as possible, and the dataset size is about 1/7th of the size of some of my other datasets, and these other datasets refresh fine. Could there be an issue with some of my visuals and DAX commands in the report - would these affect the schedule refresh of the dataset? The report can be refreshed on my local machine with no issues.

I can send the report with sample data over via private message if that is useful.

Thank you!

[v-zhangti]

Hi, @oliverblane 

For a full refresh, recall that at least double the current dataset memory size is required. If sufficient memory is not available, then the refresh cannot commence until model eviction frees up memory - this means delays until one or more datasets becomes inactive and can be evicted.

You can try the following methods to solve the problem.

• Decrease the model size, or convert to DirectQuery mode. 
• Scale-up the capacity.
• Assign the content to a different capacity.

Here are the relevant documents, hope it can help you.

https://docs.microsoft.com/power-bi/enterprise/service-premium-capacity-optimize#optimizing-models 

Best Regards,

Community Support Team _Charlotte

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

[oliverblane]

Hi @v-zhangti, thanks for your reply.

Where can I monitor dataset evictions?

[luisrh]

Please note that if there are other datasets in memory at the time it's also taken into consideration.   Look at the capacity metrics application from powerbi apps store and install it for your capacity.  there you should be able to see all that is impacting your capacity's memory.

[oliverblane]

Hi @luisrh, thanks for your reply.

I have downloaded the app, but I never seem to go above the CPU limit:

There are also no overload minutes for the dashboard that is failing. Is there something else I should be looking at? 

[arvindsingh802]

This happens when your dataset require more memory than available memory in the premium capacity, as you have reduced the size of your dataset thus it is refreshing fine now.
You can refer Data reduction techniques for Import modeling - Power BI | Microsoft Docs to reduce your dataset size

[oliverblane]

Hi @arvindsingh802, sorry if I did not make myself clear - the dataset is not refreshing fine, despite being 1/7th of the size of the other datasets that do refresh fine.

[arvindsingh802]

Have you tried refreshing different time ?
Also share the current Premium capacity details and dataset size

[oliverblane]

Hi @arvindsingh802, thank you for your reply.

The capacity has 3GB of memory, and the dataset is 11MB according to Power BI service.

Please do let me know if there are any other specific details that I can provide, or if you would like me to share the pbix file with you.