Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0

[eliassal]

Hi, I am trying to point a report (from my desktop) to 2k19 sql server on a win2k19 as well, when I try to apply any changes, I get the following error:

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)'

From same desktop, using PowerBI desktop I access another sql2k17 without any issue 

After googling,  I came th came across some threads suggesting installing SSMS on the  server to check, it runs fine.

Any help would be appreciated

[Rudz]

We had another reoccurence of this issue. We found that most users were able to resolve by re-installing .NET Framework, but for one user it wasn't solved until they deleted and re-added the data source credential in Power BI Desktop. The next time we run into this, that's where we are starting!

[davidwc]

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:

1. Impersonate a client after authentication 
2. Obtain an impersonation token for another user in the same session

May have to reboot after making the changes.

[Kinson_Lam]

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?

[datagestuurd]

Hi @eliassal,

Well actually it does has something to do with PowerBI.

Run PowerBI as Administrator and it will solve the problem.

Probably you are trying to connect with a seperate user that has rights on the machine.

When you connect with your own login everything is oke but somehow with impersonation you need some extra rights. Hopefully this is also a solution in your situation.

If this was a solution to the problem please set the item to solved. In that way it can help others that run to the same problems.

Stefan Mulder

http://datagestuurd.nl

[Alps123]

Hi....
Thank you so much.....
It has worked for me...
I have tried it for last 3 days.....
I got the solutions......

Thank you so much 

[Rudz]

@eliassal  A user here had the same issue. Another user had no problems with the same account, pointing to a software issue. This article recommended re-installing .NET Framework which cleared the error for the user.

[v-xicai]

Hi @eliassal ,

You can connect to SQL Server in Power BI Desktop using SQL authentication credentials. Choose Database option in the following screenshot, then enter your username and password to connect to SQL Server. See more details: Connect Power BI to SQL Server.

You may try to upgrade the Power BI Desktop to the latest version 2.81.5831.821.

In addition, you may find error message from here, go to File-> Options and Settings ->Options ->Diagnostics.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[eliassal]

You are correct, I used sql credentials and connection went through, I will try to download and setup the new version

Thanks for your help

[eliassal]

I forgot to mentiuon that the version is already 2.81.5831.821 May 2020

[v-xicai]

Hi @eliassal ,

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", or go to Issue forum  to get further help.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[eliassal]

Issue resolved by using sql credentials but still I cant with windows credentials, I will do

[parry2k]

@eliassal are you able to connect to sql server from other tools except Power BI?

[eliassal]

Yes, from SSMS from same desktop as well as C# projects

[parry2k]

@eliassal so it is nothing to do with Power BI, I think it is the issue with the machine that it cannot connect to the SQL server, try on a different machine and see if it works.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[eliassal]

As I said, from same desktop

Yes, I can connect PowerBI to another sql2k17 as well as other versions of sqL on other windows version.

I can connect through SSMS to the sql2019 (which has the issue) as well as other servers

I can access sql 2019 from C# projects

I am not sure that it is a problem with the desktop, I have the impression that PowerBI is not able to talk to SQL2019

OK, how this can be debugged or which route to follow to unearth the issue and see where the peobleme lies?