cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
egonzalez
Regular Visitor

Power BI Report Server Performance Issue

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,

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
Icey
Community Support
Community Support

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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.