Report Refresh impact on Database and sometime fails

[Anonymous]

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]

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

[GilbertQ]

Hi there

See if you disable the parallel loading of tables in your PBIX and see if that helps?