Power BI Report Server scheduled Refreshes

Hi, sara_sameer 

To optimize the refresh process and reduce the total time required, consider the following recommendations:
Ensure that your report server and database server have sufficient resources (CPU, memory, I/O capacity) to handle multiple concurrent refresh operations. Monitor performance during refreshes to identify any bottlenecks.
Stagger refresh times: Instead of scheduling all reports to refresh at the same time, stagger refreshes by a few minutes. This reduces the likelihood of resource contention and helps ensure a smoother operation. For example: schedule Report 1 to refresh at 12:00, Report 2 at 12:02, and Report 3 at 12:04.
If a sequential refresh is acceptable, use a single schedule:
If sequential refresh times (refreshing reports one by one) are acceptable, using a single schedule simplifies administration and avoids server overload.
Optimize report queries: Ensure that queries used in reports are optimized for performance. Efficient queries reduce the time required to refresh each report. Consider indexing, query optimization and ensure that the database design supports efficient data retrieval.
Monitor and tune: Continuously monitor refresh performance and tune as needed. Use server logs, performance counters and database monitoring tools to gather insights.
Consider load balancing: If you have multiple reporting servers or load balancing setups, distribute refresh tasks between servers to improve performance.

hackcrr

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