Forum Discussion
bkan6741
Mar 28, 2024Copper Contributor
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_bbbCopper ContributorYou 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