Forum Discussion
Gateway settings to maximize the remote server utilization to refresh datasets
Hello Everyone, I am trying to refresh the datasets(large datasets) on PBI service. The dataset is built on on-prem database datasource and refreshed using an on-prem gateway. When I logon to the...
nitishsh91
Solution Supplier
Solution SupplierHi vg_pbiuser
Please update 2 parameters in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config :
CPUUtilizationPercentageThreshold
MemoryUtilizationPercentageThreshold
Please have a look at below url:
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance
Yes Nitish and thanks for the response. We did look into these parameters. However, by default it was disabled and which means it has to utilize 100 % of CPU or Memory. We tried to explicitly set the parameters to 80%, to notice any changes in the usage. We haven't seen any improvement in terms of usage. Is there anything else that could effect this ?