Getting an error when loading in data via SQL Server Query

[TWicks]

My company just implemented Power Bi so it's possible I'm missing something obvious. I was able to load data in through SQL Server queries last week but have been hit this week with this error message:

Unable to connect

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'"

The weird thing is I started getting this error on Monday or Tuesday. Wednesday morning I was able to load in data but then Wednesday afternoon through to today(Friday) I just get the error again. The other 2 people in my office with access to Power Bi do not get this error. I have tried repairing my .NET Frameworks, I have updated Power Bi and I have upped the values under Parallel loading of tables to just under the recommended threshold.

I'm happy to provide more details if this post is a bit vague. I appreciate any and all help!

[Anonymous]

Hi @TWicks ,

One user reported that deleting and re-adding the data source credentials in Power BI Desktop resolved the issue for them.

Another potential cause could be related to the impersonation level. Ensure that the user account you are using has the necessary permissions. You can check and modify these settings in the Local Security Policies under Administrative Tools.

Best Regards,
Community Support Team _ Caitlyn