Forum Discussion
Can not connect to the server
Hi Kavi_9907 ,
Thanks for sharing the update.
The error you are now seeing "Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'" is usually related to missing or corrupted .NET Framework components that Power BI depends on. You can try the following:
-
Ensure that the .NET Framework is properly installed and up to date on your machine. Repair or reinstall the .NET Framework if required.
Microsoft provides .Repair the .NET Framework - .NET Framework | Microsoft Learn.
.NET Framework & Windows OS versions - .NET Framework | Microsoft Learn -
Make sure Windows and Power BI Desktop are updated to the latest versions.
-
Clear saved data source credentials from Data Source Settings -> Edit Permissions, then re-enter the SQL credentials.
-
If the issue persists, try reinstalling Power BI Desktop after repairing .NET.
Similar issue threads:
Solved: Getting Connection error while connecting SQL Serv... - Microsoft Fabric CommunityCould not load file or assembly 'System.Enterprise... - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.
-
Community SupportHi Kavi_9907 ,
Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.
Thank you.
now database works when i open it through ssms seperately but when i import data into power bi, it gets an error.
"Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'"
- v-veshwara-msft
Hi Kavi_9907 ,
Thanks for sharing the update.
The error you are now seeing "Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'" is usually related to missing or corrupted .NET Framework components that Power BI depends on. You can try the following:
-
Ensure that the .NET Framework is properly installed and up to date on your machine. Repair or reinstall the .NET Framework if required.
Microsoft provides .Repair the .NET Framework - .NET Framework | Microsoft Learn.
.NET Framework & Windows OS versions - .NET Framework | Microsoft Learn -
Make sure Windows and Power BI Desktop are updated to the latest versions.
-
Clear saved data source credentials from Data Source Settings -> Edit Permissions, then re-enter the SQL credentials.
-
If the issue persists, try reinstalling Power BI Desktop after repairing .NET.
Similar issue threads:
Solved: Getting Connection error while connecting SQL Serv... - Microsoft Fabric CommunityCould not load file or assembly 'System.Enterprise... - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.
- v-veshwara-msft
Hi Kavi_9907 ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.
-