Forum Discussion
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 LearnThe 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.
Super UserThat is not likely to happen. The gateway is designed to process the data as fast as possible so that your data is refreshed as fast as possible. If you ran at 50% CPU then the process would take twice as long.
Better options would be to look at what data refresh is running during that time frame and see if you can tune it at all to reduce the CPU load or change the alert settings on your hypervisor for this VM
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)
- d_gosbell
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 LearnThe 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.