Impacting to other power bi scheduled report's refresh, when we scheduled every 10 or 30 mins
We're using Power BI On premise report server, most of our power bi users are using schedule refresh feature . Here, some of our users are scheduling their reports to execute every 10 mins, 15 mins or 30 mins. Due to this, it's impacting to other scheduled reports like as below example.
For example , if a report has scheduled for today at 8 am , but it's getting picked up by next day 5 pm i.e. running by 1 day late approx. and slowly this keep increasing and report which was about to run today is getting run by 2 weeks after and so on. This is happening because of most of the users started refreshing their reports at every 1 min , 5 mins , 10 mins, 15 mins …intervals on daily basis due to which all refreshes are getting queued up there by impacting the regular refreshes and causing delay.
To fix this issue temporarily, we have informed to our users that in order keep going this process smoothly, have minimum “1” hour as refresh interval benchmark and not less than to that.
For suppose, if we've a second server ( i.e. gateway server ) , will be able to fix this issue ? Please suggest us how to overcome this issue.
Current, our power bi report was configured with 14 CPU Cores , 48GB Memory and OS is Windows Server 2016 .