Error connecting Excel or PowerBI to SQL Server (System.EnterpriseServices)

Question

I've setup a SQL server on my local network, and I can connect to it no problem with SSMS. But when I try to connect to it via Excel or PowerBI, I get the following 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)'"

In researching this error, some of the solutions proposed were:
1: Start Excel or PowerBI as admin
2: Reinstall .NetFramework

I tried both, and it doesn't work. Would someone be able to help?

Thank you in advance.

Answer 1

Hi @JKith

The issue might from inside pbix file, and it was due to the automatic changes applied in the report data source settings.

Cleared all the permissions for the data sources that had this problem (some of them were with "Windows" credentials and "Organizational" privacy level). Then, set the Credentials to Windows again with the current user authentication and privacy level to "None", all the Credentials encrypted.

Hope this helps :)