Forum Discussion

amir_mm's avatar
amir_mm
Icon for Helper III rankHelper III
2 years ago

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

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 data...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
    amir_mm
    Icon for Helper III rankHelper III
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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.