Power BI Report Server Performance Issue

[egonzalez]

Hi,

Two weeks ago, I suddenly started having performance issues with Power BI Report Server (on-premise). I have been using Power BI Report Server since January 2021. I have 12 Power BI Reports that I have been refreshing on a monthly basis. About 2 weeks ago, the reports started taking an unusually longer time (about 15 seconds) to load on the page for anyone browsing the report. Also, when slicing/filtering through the charts, it now takes nearly 5 seconds for the page to reload data . These same reports used to load almost instantaneously as well as filter instantaneously for the past 5 months or so.

To troubleshoot, I confirmed nothing changed with the data being used on the reports that would cause a performance issue. I also looked at the Performance Analyzer in Power BI Desktop as well as the PBIR Server. No issues were flagged and the servers involved are not anywhere close to being resource constrained. I upgraded the version of the Report Server to the May 2021 version. This also did not help. I rebooted the Servers and this did not help either.

Does anyone have any ideas as to what is causing the reports to load so slowly? I tested the reports in Power BI Service and they worked instantaneously so I have to believe that the issue resides in Power BI Report Server.

Thank you for any insights,

[Icey · Accepted solution]

Hi @egonzalez ,

Please refer to this blog to troubleshoot slow reports in PowerBI Report Server. 

---

In the report server database (ReportServer by default) there is a view (ExecutionLog) that can provide detailed statistics about each execution of a report. Note: ExecutionLog3 view is the newest/current version and the ExecutionLog and ExecutionLog2 views are for backwards compatibility. By default the execution log entries are retained for 60 days.

To configure report execution logging:

1. Connect to the report server instance with SQL Server Management Studio.
2. Right-click on the instance name and select Properties
3. On the Logging page:
   • Select (or deselect) Enable report execution logging.
4. On the Advanced page select the User-defined section:
   • ExecutionLogLevel can be set to verbose or normal.

---

Hope this could help you.

Best Regards,

Icey

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