I get an error when I connect to the local installed SQLserver and try to load data into PowerBi.

Uco Suierveld 20 Reputation points
2025-01-22T15:25:46.0966667+00:00

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

I installed the latest version os SQL and MSSMStudio.

Please help so I can continue my online courses.

Thanks in advance

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,377 questions
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
38 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 40,051 Reputation points
    2025-01-23T03:14:14.77+00:00

    Hi @Uco Suierveld,

    You may try to run the Desktop as admin.

    Also, you may refer to below thread to see if it is helpful.

    https://community.fabric.microsoft.com/t5/Desktop/Could-not-load-file-or-assembly-System-EnterpriseServices/m-p/3669051#M1198833

    You may also raise the issue to PBI community there to get more advice from PBI side.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Uco Suierveld 20 Reputation points
    2025-01-25T16:01:53.3233333+00:00

    It worked, I can continue my online course and finish it! Thanks a lot!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.