Forum Discussion
memory error while autorefresh in power bi report server
There are some reports on the Power bi report server. These reports have different sizes. Each report is connected to the auto refresh and each report has its own refresh time. However, 3 of these reports give errors during auto refresh like Memory error and do not refresh, therefore old data appears in the visuals. .
I want to give an example of a report. In this report, the dataset consists of SQL view and excel tables and measures. The view between the tables in the dataset has a large volume. All the columns in the view are necessary for the report. Most of the time, this view is refreshed.
As it is known, power auto refresh deletes and rewrites all the data in the table in the dataset. This takes a lot of memory and causes a memory error during the refresh. How can you refresh only the data on sysdate-1 during the refresh? keep it as it is, don't refresh it.
When I get such an error, I edit the report and manually refresh all the tables in it. After doing this, I save the report again. But it takes too much time and it no longer works.
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.
1 Reply
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.