Forum Discussion
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 ...
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
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