Forum Discussion
Power BI Report Server Scheduled Refresh Bottleneck Problem
Hi gkc9
Thank you for reaching out to the Microsoft Fabric Forum Community.
The 100% CPU from msmdsrv.exe is happening because too many refreshes are running at the same time, and each one uses multiple CPU threads. This overloads the system, so even with good hardware, the portal hangs.
In Power BI Report Server, there’s no strong built-in control, so you need to limit how much runs in parallel. You can tune settings like CoordinatorExecutionMode (around 6–10) and MaxThreads (around 16–24) to reduce parallelism. Also, use MaxQueueThreads (8–12) to limit how many refreshes start together.
Maybe, the issue is too much parallel work not weak hardware. try Reduce concurrent refreshes and spread them out to stabilize the system.
If there are any deviations from your expectation please let us know we are happy to address.
Thanks.
Hi gkc9
Thank you for reaching out to the Microsoft Fabric Forum Community.
The 100% CPU from msmdsrv.exe is happening because too many refreshes are running at the same time, and each one uses multiple CPU threads. This overloads the system, so even with good hardware, the portal hangs.
In Power BI Report Server, there’s no strong built-in control, so you need to limit how much runs in parallel. You can tune settings like CoordinatorExecutionMode (around 6–10) and MaxThreads (around 16–24) to reduce parallelism. Also, use MaxQueueThreads (8–12) to limit how many refreshes start together.
Maybe, the issue is too much parallel work not weak hardware. try Reduce concurrent refreshes and spread them out to stabilize the system.
If there are any deviations from your expectation please let us know we are happy to address.
Thanks.
Hi @gkc9
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.