Forum Discussion
Power BI Report Server Performance Issue
- 5 years ago
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:
- Connect to the report server instance with SQL Server Management Studio.
- Right-click on the instance name and select Properties
- On the Logging page:
- Select (or deselect) Enable report execution logging.
- 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.
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:
- Connect to the report server instance with SQL Server Management Studio.
- Right-click on the instance name and select Properties
- On the Logging page:
- Select (or deselect) Enable report execution logging.
- 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.