Gateway Server

[vshiva]

I am working on a Power BI Gateway server which serves many reports to variety of users. When I analyse the Processor Performance, I could see that "% Processor time" shot up at times reaching 100% and causing a delay in the refreshes. Looking for any inputs on how to balance the load and keep the % Processor time to less than 80% all the time. Any lead or guidance is very much appreciated. Thanks.

[v-yuta-msft]

Hi vshiva,

"Looking for any inputs on how to balance the load and keep the % Processor time to less than 80% all the time. "

<---- Could you clarify more details about your requirement for further analysis?

Regards,

Jimmy Tao

[vshiva]

We are having hundreds of datasets getting scheduled refreshed parallely in Power BI service. At times the Processor time is more than 80% which is affecting the performance of the CPU and the delay in scheduled refreshes. We also faced certain instances where the scheduled refersh was failed as many datasets were getting refreshed simultaneously. 

We already have very good Server Configuration and this problem occurs occasionaly. So, upgrading the CPU might not be possible for us.