Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello Community,
we would like to use power bi and I get no connection to our SQL Server 2012.
I have read the most posts to this topic but i don´t get it to work.
I want to establish a connection to my SQL Server mith "DirectQuery" and i get
only a failure Message:
No connection could be established...
(in german:
Details: "Fehler beim Lesen von Daten aus dem Anbieter: "Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Entweder wurde eine geforderte Identitätswechselebene nicht geliefert, oder die gelieferte Identitätswechselebene ist unzulässig. (Exception from HRESULT: 0x80070542)""
I have tried different logins and the SQL Login doesn´t work too.
Couldt please anybody help. I haven´t a clue what to do 😉
Thx
Solved! Go to Solution.
As mentioned in error message: "Could not load file or assembly 'System.EnterpriseServices". Please reinstall your .NET Framework (3.5 or above), restart your computer and try again.
Regards,
Hello,
it installed the framework 4.5 and boot the system and now it works.
Thx
Problem ist solved.
Hello,
it installed the framework 4.5 and boot the system and now it works.
Thx
Problem ist solved.
As mentioned in error message: "Could not load file or assembly 'System.EnterpriseServices". Please reinstall your .NET Framework (3.5 or above), restart your computer and try again.
Regards,
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 36 | |
| 32 | |
| 31 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |