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!