Getting Connection error while connecting SQL Server Database to power bi.

[R_A_H_U_L]

Getting this Error:

We encountered an error while trying to connect:

Details: "Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'"

Please help me understand this error & resolve it.

[cordycep]

Have same error, are you using a gateway?

[Anonymous · Accepted solution]

Hi @R_A_H_U_L ,

Thanks for lbendlin's reply!
And @R_A_H_U_L , you can try this steps which may help:
Sometimes, running Power BI Desktop with administrative privileges can resolve this issue.
Ensure that the .NET Framework is properly installed and up to date. You can repair or reinstall the .NET Framework if necessary.
Make sure that the System.EnterpriseServices assembly is up to date. You can check for updates or reinstall the assembly if needed.
If you previously connected to the data source using different credentials, try clearing all connection permissions and restarting Power BI.

And maybe these links will help you:
Solved: Unable to Connect to SQL Server - Microsoft Fabric Community
Error Unable de connect sql with Power BI - Microsoft Fabric Community

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

[R_A_H_U_L]

Running Power Bi with Administrative Privileges worked for me. I might have used some different data source credential so I cleared all connection permission & started fresh. It worked! Thanks!

[lbendlin]

some guidance: Could not load file or assembly 'System.Enterprise... - Microsoft Fabric Community