Forum Discussion

Snagalapur's avatar
Snagalapur
Helper IV
9 months ago
Solved

Gateway data refresh error

Hi All,   Please suggest why we get below error during Gateway refresh in Power bi sever ?  
  • grazitti_sapna's avatar
    9 months ago

    Hi Snagalapur 

     

    This error occurs because the dataset refresh tried to use more memory than allowed by the assigned Power BI capacity (for example: used 23,269 MB vs. allowed 22,595 MB).

     

    To resolve this try the following and let us know if it works:

    • Reduce the size of your data model by removing unnecessary fields and optimizing Power Query steps.
    • Use incremental refresh where feasible.
    • If you are on Power BI Premium, consider upgrading to a higher SKU for a larger memory limit.
    • Analyze your model with tools like DAX Studio to identify and optimize large tables/columns.

    Optimizing the model and/or moving to higher capacity are the main ways to resolve this error.

     

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

    🔗 Curious to explore more? [Discover here].

    Let’s keep building smarter solutions together!