hi,@IG-0063
I did some test locally,I changed the connection authentication of the data source in the report, and found that the windows authentication was a little bit slower, it was 1 second slower.
Have you tested other simple report on this issue, or only this report has this issue?
I recommend you check the ExecutionLog of the reporting service.
Specific steps:
- connecting the sql server database by SSMS
- open the reportserver database
- preview the report
- create a query "select top 5* from ExecutionLog3 order by TimeStart desc" and run
then you can see the record of the report just ran.There are 3 parameters you may focus on,timeDataRetrivel,timeProcessing and timeRendering.You may check the 3 stages to find out which stage cause slowness.
ExecutionLog Information : https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15
Also If you want to improve the report server performance, you can refer to this: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/performance-snapshots-caching-reporting-services?view=sql-server-ver15
Best Regards,
Isabella
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.