Forum Discussion
Updated Gateway Issues
- 1 year ago
Hi ybarsabal ,
The Power BI Gateway update appears to have introduced performance issues, leading to failed refreshes due to timeouts and memory exhaustion. Since no changes were made to the reports or schedules, the problem likely stems from the gateway's new configuration, increased resource consumption, or an issue with data source connectivity post-update. The timeout error suggests that queries are taking longer to execute, possibly due to network latency, query inefficiencies, or SQL Server performance bottlenecks.The memory evaluation error indicates that the Power Query engine within the gateway is running out of resources while processing large datasets. To resolve this, first, check the gateway server's CPU and memory usage to ensure it has sufficient resources.
Additionally, verify that the SQL Server connection settings (such as timeouts and query optimizations) are correctly configured and that the latest version of the gateway matches the compatibility requirements of your reports. You can also try restarting the gateway service, reducing the data load per refresh, or splitting large queries into smaller, more efficient ones. If the issue persists, consider rolling back to a previous stable version of the gateway or checking the Power BI support forums for known issues with the latest update.
Hi ybarsabal ,
The Power BI Gateway update appears to have introduced performance issues, leading to failed refreshes due to timeouts and memory exhaustion. Since no changes were made to the reports or schedules, the problem likely stems from the gateway's new configuration, increased resource consumption, or an issue with data source connectivity post-update. The timeout error suggests that queries are taking longer to execute, possibly due to network latency, query inefficiencies, or SQL Server performance bottlenecks.
The memory evaluation error indicates that the Power Query engine within the gateway is running out of resources while processing large datasets. To resolve this, first, check the gateway server's CPU and memory usage to ensure it has sufficient resources.
Additionally, verify that the SQL Server connection settings (such as timeouts and query optimizations) are correctly configured and that the latest version of the gateway matches the compatibility requirements of your reports. You can also try restarting the gateway service, reducing the data load per refresh, or splitting large queries into smaller, more efficient ones. If the issue persists, consider rolling back to a previous stable version of the gateway or checking the Power BI support forums for known issues with the latest update.
- v-aatheeque1 year agoCommunity Support
Hi ybarsabal ,
we wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
If our response has addressed by rohit1991 GilbertQ your query, please accept it as a solution so that other community members can find it easily.
- v-aatheeque1 year agoCommunity Support
Hi ybarsabal ,
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!