Forum Discussion
Power ParticipantPower Bi report server January 2024 slow data driven email subscriptions
Hi gooranga1 ,
Firstly, it's important to note that adding more cores to your server might not always result in improved performance for Power BI Report Server. The performance can depend on various factors, including the nature of the reports, the data model, and how the server is being utilized.
Capacity planning guidance for Power BI Report Server - Power BI | Microsoft Learn
Slow performance can sometimes be attributed to inefficient report designs or data models. Consider reviewing and optimizing your reports and data models.
If it does not help, please provide more details.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power ParticipantWe send a lot of subscriptions and always have for years without issue. We manage these subscriptions and we know not to run big reports at critical times which for us is between 08:00 and 09:00. These delays were not gradual they were instant on the day after we upgraded the report server to Januarry 2024. Below is a screenshot showing the difference between the 28th Feb 2024 and 29th Feb 2024. We upgraded the report server on the afternoon of the 28th Feb. Nothing else changed, all the subscriptions were identical from one day to the next. This is just one example as we send around 400 in this hour. All of them delayed.
The Notifications table fills up and will process between 5 and 7 emails per minute at best.
The only thing that changed was the server version.