memory error while autorefresh in power bi report server

Hi, Anonymous 

You might consider using incremental refresh, which allows you to refresh only the data that has changed (for example, data from sysdate-1) instead of the entire dataset, which can significantly reduce memory usage. When you set up incremental refresh in Power BI Desktop, you need to define the parameters for the date range and configure the incremental refresh policy. For more information, please click here:

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

Or optimize the data model, reduce the size of the data model, and remove unnecessary columns and tables. Aggregate data to minimize the amount of data processed. Optimize DAX calculations to ensure they are as efficient as possible.
If possible, increase the memory allocation for Power BI Report Server. The load can be distributed by adjusting server settings or scaling the deployment. Or use Performance Analyzer in Power BI Desktop to identify and optimize slow queries. Monitor server memory usage and performance to identify bottlenecks. You can use tools such as SQL Server Profiler or Performance Monitor. You can check the following link:

Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

If all else fails, you may want to use manual refresh as a last resort, but try to use PowerShell scripts or other automation tools to automate the process.

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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