Forum Discussion
Severe Report Rendering Performance Degradation on May 2021 release
Hi,
We aren't using the portal preview... but we did find the solution, so wanted to post here.
The timing was purely coincidental, but there scheduled refresh was set up only days after the upgrade to the May 2021 release. That scheduled refresh was set up to run every minute of every day. This heavily affected performance on the rest of the report server (without impacting the overall CPU/Memory stats). Once we updated that refresh to run every few hours, report server performance improved significantly.
Hi daxman !
Please try to investigate Report Load time using ExecutionLogs table in Power BI ReportServer DB. You can see ExecutionLog2 & ExecutionLog3 table to identify what was the report rendering / loading time previously before Power BI Report Server Upgrade and now.
Also, if you are using PortalV2, please try to revert your settings to default potral. You can use follwing script to revert to original settings; You need to run the script on Power BI Report Server DB.
/****** Script to DISABLE Portal preview ******/
UPDATE [ReportServer].[dbo].[ConfigurationInfo]
SET [dbo].[ConfigurationInfo].Value = 'false'
Where [dbo].[ConfigurationInfo].Name = 'UsePortalV2'
Regards,
Hasham
Hi,
We aren't using the portal preview... but we did find the solution, so wanted to post here.
The timing was purely coincidental, but there scheduled refresh was set up only days after the upgrade to the May 2021 release. That scheduled refresh was set up to run every minute of every day. This heavily affected performance on the rest of the report server (without impacting the overall CPU/Memory stats). Once we updated that refresh to run every few hours, report server performance improved significantly.