Forum Discussion
Helper IICould not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0
Found a possible solution for this. I was running into the problem when using a domain [service] account to authenticate to an MSSQL 2019 server and the user was different from the one I was currently logged in as.
It appears that this is a problem with application impersionation and how PowerBI handles it. Had to use an administrator account to make the changes.
Start > Control Pannel > Administrative tools > Local security policies > Expand local policies > Select User Right Assignment.
Added my logged in user to the following policies:
- Impersonate a client after authentication
- Obtain an impersonation token for another user in the same session
May have to reboot after making the changes.
I have exactly falled into this scenerio. I will need to use another window domain account to login MS SQL SERVER 2019 in my power query and it gave same error
Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"
I tried your method to change the local security policies by adding my domain account to "Impersonate a client after authentication" and "Obtain an impersonation token for another user in the same session", but problem still persist.
Any idea/suggestion?