Forum Discussion
PBI Model refresh failed with memory issue
Hello -
I am facing below error once and all the visuals appear broken with same error -
How can I troubleshoot or resolve this error? What has caused this memory issue particularly during one run and we had successful refreshes after that. Apprecaite any insights.
"Memory error: You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory"
Broken visuals can be caused by inefficient measures or by other semantic models consuming all the available memory in your capacity. Use the metrics app to check.
13 Replies
What Power BI or Fabric SKU are you using?
Hi lbendlin SaiTejaTalasila - Would model refresh failure cause the visuals on the report break as well? I assume that models will not reflect the failures on the report unless processing is complete and reports continue to display the previous refreshed data. we are performing full refresh type on the pbi models in premium capacity.
It's much more nuanced than that. Don't forget that after the semantic model refresh (the mashup) you still have to update the calculated columns and calculated tables when the model is loaded into memory.
And then you can have inefficient measures that can finish the job with a nice big cartesian or two.
Is Recalc of the model required even when model refresh is performed as "full" refresh type?
