Forum Discussion

egonzalez's avatar
egonzalez
Frequent Visitor
5 years ago
Solved

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 t...
  • Icey's avatar
    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:

    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.