Forum Discussion

bkan6741's avatar
bkan6741
Copper Contributor
Mar 28, 2024

Report Rendering Very slow when accessed from URL

Hi All,

I have both power bi and SSRS report (same report and same data source SQL Server VIEW). When I run the SSRS report in VS it renders the data in few seconds, same is the case with the Power BI report, it renders the data (half a million rows) in seconds from the desktop. The issue is when I deploy these reports to the Report Server , it takes around 5-6 mins to render the data, any suggestions as where should I start to look at , to check where the latency is? Please advice. Is there any TSQL Query that I can run to check the latency? If the issue is on the database end then it must be slow on the VS and Desktop as well , that is my thought.

Thanks

  • ih_bbb's avatar
    ih_bbb
    Copper Contributor
    You may want to check for parameter sniffing. So if you are passing some values from parameters, you may want to create a local variables in your query, and in that query, refer to that local variable.
    Example:
    parameter name in your rdl - @param1

    In your query, use something like this:
    declare @lv_param1 int
    set @lv_param1 = @param1

    then in your query, you use select <something> where <some column name> = @lv_param1

    Good luck

Resources