High severityauthentication
Power BI Refresh Error:
HRESULT: 0x80070542
What does this error mean?
Power BI Desktop fails to load System.EnterpriseServices when connecting via alternate Windows credentials, throwing HRESULT 0x80070542. This occurs because the alternate account lacks sufficient local system permissions to register required DLLs.
Common causes
- 1The alternate Windows account specified under 'Use alternate credentials' does not have permission to register system DLLs on the local machine
- 2IT Group Policy restricts impersonation rights for non-primary Windows accounts on the workstation
- 3The System.EnterpriseServices assembly cannot be loaded under the alternate account's security context due to insufficient impersonation level
- 4The local account configuration set by the IT department blocks the alternate account from accessing required COM+ or enterprise services components
How to fix it
- 1Step 1: Avoid using the 'Use alternate credentials' option in Power BI Desktop — instead, log into Windows directly with the account that has access to the data source.
- 2Step 2: Contact your IT administrator to verify whether the alternate Windows account has local impersonation rights and permission to register DLLs under its security context.
- 3Step 3: Ask IT to grant the alternate account the 'Impersonate a client after authentication' local security policy right via Group Policy or local policy editor (secpol.msc).
- 4Step 4: If the connection must use alternate credentials, consider configuring the data source credentials through the Power BI Service or an On-premises Data Gateway instead of Power BI Desktop.
- 5Step 5: As a workaround, use Windows 'Run as different user' to launch Power BI Desktop entirely under the alternate account, avoiding the impersonation chain that triggers this error.