Recently I worked on a Power BI case. The Power BI Personal Gateway fails to install. The error is
Service ‘Data Management Gateway Service’ (DIAHostService) failed to start. Verify that you have sufficient privileges to start system services.
In the log file, you may see the following message
Error 1920. Service ‘Data Management Gateway Service’ (DIAHostService) failed to start. Verify that you have sufficient privileges to start system services.
The system event log shows the a better error message
The DIAHostService service was unable to log on as NT SERVICE\DIAHostService with the currently configured password due to the following error:
Logon failure: the user has not been granted the requested logon type at this computer.
Domain and account: NT SERVICE\DIAHostService
This service account does not have the required user right “Log on as a service.”
Cause: This NT SERVICE\DIAHostService account is created during the setup. This NT SERVICE\DIAHostService account is created and used as the default service account for the Data Management Gateway service before it is configured to run under a domain account.
Solution: I found this user is in the Performance Log Users and Performance Monitor Users local groups.
Open the Local Security Policy, expand Local Policies, then expand User Rights Assignment. Find the Log on as a service, policy, open the policy, add Performance Log Users to the list.
Make sure the Deny log on as a service policy is empty.