When attempting to access a SQL server/database in Power BI, you might get the following error message:
Unable to connect
We encountered an error while trying to connect.
Details: “An error happened while reading data from the provider: ‘Could not load file or assembly ‘System.EnterpriseServices, Version=22.214.171.124, Culture=neutral, PublicKeyToken=…..Error message received when trying to get a SQL database as a data source in Power BI
You just need to run Power BI as administrator before attempting to access the SQL database as a data source.
- Save your work and close Power BI Desktop
- Right click Power BI Desktop and select “Run as administrator”
3. Attempt to access your database again – you shouldn’t have an issue.