Gateway data refresh error

[Snagalapur]

Hi All,

Please suggest why we get below error during Gateway refresh in Power bi sever ?

[v-karpurapud]

Hi @Snagalapur 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[v-karpurapud]

Hi @Snagalapur 

Thank you for contacting the Microsoft Fabric Community Forum.

As noted by @grazitti_sapna , the error is caused by a memory outage. We appreciate your engagement and the valuable solutions you contribute to the community.

To summarize, this error typically happens when the dataset refresh exceeds the available memory allocated for the Power BI capacity. The recommended steps provided are valid  reducing the dataset size by optimizing Power Query steps, using incremental refresh where feasible, upgrading to a higher Premium SKU for increased memory, and analyzing the model with tools like DAX Studio to identify large tables or columns are all effective ways to resolve this issue.

If you have further questions or need additional support, please reach out. We are here to assist you.

Best regards,
Microsoft Fabric Community Support.

[grazitti_sapna · Accepted solution]

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!