Forum Discussion

R_A_H_U_L's avatar
R_A_H_U_L
New Member
1 year ago
Solved

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

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' f...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.