Auto refreshing canceled because there wasn't enough memory to finish running it!

[amir_mm]

Hello,

Our dataset is not refreshing and getting this error:

"This operation was canceled because there wasn't enough memory to finish running it. either reduce the memory footprint of your dataset, or if you are using Power BI premium, increase the memory of the premium capacity where this dataset is hosted. Cosumed memory: 3093MB, memory limit 3062MB, database size before command execution 2057MB"

Info:

The dataset Pbix file size is: 574MB

Used Vertipaq analyzer and the total RAM when data is loaded into the RAM is 1.9 GB

Having premium - A2 capacity which should provide 5GB memory. 

Datasource: SQL Database (in Azure)

Largest table has 9.5M rows.

Any suggestion is appreciated. 

[aj1973]

Hi @amir_mm 

If not opting to increase memory of the premium capacity then tunning up the dataset is a must. A DAX formula can be the cause and needs optimisation, Relationships, Unused columns need to be removed..

[amir_mm]

Thank you Amine.

Given that we are on A2 premium capacity with a 5GB memory limit, and the total memory usage when loading the model into RAM is only 1.9GB, why are we facing this error? Does this imply that additional memory is being utilized elsewhere?

Thanks!

[Anonymous]

Hi @amir_mm ,
Since you are using A2 Premium capacity, make sure that you are not exceeding the SKU's memory limit due to other datasets or operations running at the same time. Consider scheduling refreshes during off-peak hours when other workloads are at a minimum.
If necessary, please consider upgrading to a larger Premium capacity to provide more memory.

Best Regards,

Ada Wang

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