Reduce CPU for Microsoft.PowerBI.EnterpriseGateway.exe

---

MiLANche wrote:

Thanks mate,  On the other hand, I've asked PBI admins to let me know (as System Admin)  what types are 

Cache Data workload   (using high CPU)

Live Connection and Direct Query  workload  (much less demand for CPU)

---

The different workloads are outlined here:
On-premises data gateway sizing - Power BI | Microsoft Learn

The cache data workload is where Power BI is refresh an import mode model so it is processing data to be loaded into an import mode data model.

Typically the Power Query code will attempt to push as much of the transformation logic upstream to the data source as it can, but if the transformations are complex or are not well tuned or if the data source cannot handle complex logic (such as a folder of csv files) the the bulk of the transformation logic will be done on the gateway CPU. 

As I mentioned earlier, I still think it would be worth getting someone to review the report in question or look at adjusting your VMWare alerts rather than slowing the performance of all gateway operations.