Report Refresh impact on Database and sometime fai...

Anonymous · ‎07-09-2020

The CPU usage of database is at 20% before any report is maually/schedule refresh. But during report refresh the database spikes from 20% to 94%. So when cpu usage of database is above 90% which causes report refresh failure. Due to this our reports refresh fails on daily basis.
So please kindly provide a solution for this issue.

v-lili6-msft · ‎07-10-2020

hi @Anonymous

Try to set different Scheduled refresh time for the datasets which are connected to this datasource, for example: set One dataset is refreshed every hour.

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.