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 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. 

Need Help

3 Replies

  • 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.