Forum Discussion

rahmafarhat's avatar
rahmafarhat
New Member
3 years ago

Error Unable de connect sql with Power BI

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 on...
SQL POWER BI
jaweher899's avatar
jaweher899
Impactful Individual
3 years ago

This error message is indicating that PowerBI is unable to load the System.EnterpriseServices assembly with version 4.0.0.0. The message suggests that the cause of the issue could be one of two things: either the required identity level has not been provided, or the provided identity level is not valid.

To resolve this issue, you can try the following steps:

  1. Check the dependencies: Ensure that all the dependencies of the System.EnterpriseServices assembly are installed and available on the machine where PowerBI is installed.

  2. Update the assembly version: If the version of the System.EnterpriseServices assembly that you are using is outdated, try updating it to the latest version.

  3. Check the .NET framework version: Ensure that the version of the .NET framework installed on your machine is compatible with the version of the System.EnterpriseServices assembly that you are using.

  4. Repair or reinstall .NET framework: If the .NET framework is not working properly, try repairing it or reinstalling it.

  5. Run PowerBI as an administrator: If the issue is related to the identity level, try running PowerBI as an administrator to see if that resolves the issue.

  6. Contact Microsoft support: If none of the above steps resolve the issue, you may want to contact Microsoft support for further assistance.