Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

adityavighne

SQL connect error

Submitted by Continued Contributor on ‎07-26-2017 11:12 PM

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=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"

 

Status: New
See more ideas labeled with:
13 Comments (13 New)
Comments
andyfoster
Helper I
Helper I
‎04-29-2019 07:36 AM

Hi All

 

I used the above advice as it still does work, (Running the app as Admin) but only when I used the desktop app that was installed on my machine, originally it appears the desktop bi app was being  'launched' from the store each time, I had no folder on my C: so once I logged on to the machine as an admin, downloaded powerbi desktop app, installed it, launched the app as an admin it worked!

 

Thanks for the tips

hamman
New Member
‎10-08-2019 09:05 PM
  1. Save your work and close Power BI Desktop
  2. Right click Power BI Desktop and select “Run as administrator”
SantoshKumar
Microsoft Employee
Microsoft Employee
‎03-03-2020 06:06 AM

I am also Facing this Issue:

 

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"

 

Thanks

Santosh

Idea Statuses