Memory Refresh Failure in Cloud

Hi shuhn1229 

amitchandak  Thank you for your prompt reply!

I would like to add the following points:

The error is indeed related to the Analysis Services, which Power BI uses under the hood for data modeling and refresh operations. When you're working in Power BI Desktop, the memory constraints are based on your local machine's resources, which is why you might not encounter this issue locally. However, when you move to refresh in the Power BI service, your operations are subject to the memory limits of the tier you're subscribed to.

Before considering an upgrade, try to optimize your report and the underlying data model. This includes removing unnecessary columns, aggregating data at a higher level, and using more efficient DAX expressions. For more information on optimizing your Power BI reports, please refer to the:Burstable capacity - Microsoft Fabric | Microsoft Learn

 If optimization doesn't alleviate the issue, you may need to upgrade to a higher tier with more memory. To do this, sign into the Home - Microsoft Azure, select the Microsoft Fabric service to see your capacities, and follow the steps to scale your capacity. Detailed instructions can be found Scale your Fabric capacity - Microsoft Fabric | Microsoft Learn.

Best Regards,

Jayleny

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