Slow Power BI Report RRS feed

  • Question

  • We are trying to run basic ssrs paginated reports on power bi on-prem report server but experiencing inconsistent performance issues when executing the reports with concurrent users. The report has few parameters and retrieves the data from Oracle procedure. We have changed the data source from Oracle procedure to denormalized SQL Server table with 150K records (table has indexes) and removed the parameters to troubleshoot the issue but the performance remained the same – Not Acceptable. Support tickets with Microsoft did not help us move forward with this issue. We have fine-tuned the query and rdl but no improvement. Our environment has load balanced report servers (6-cores 32GB RAM) with SQL database (4-core 16GM RAM) on a different server.  Performance gets worse as the number of executions increased.  

    Any help would be greatly appreciated.  
    Tuesday, February 11, 2020 6:03 PM