Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
When I try to connect to SQL Server I recieve an error:
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)'
But when I run PBI as administrator everything is alright. How to fix this error without using administrator's account?
Thanks in advance!
@Anonymous , what kind of auth has been used here ?
How you are trying to connect to SQL Server?
Is it working in Power BI Desktop ?
Is it giving error in Power BI Service or PBI Report Server?
Does your user have given permission to SQL DB ?
Proud to be a Super User!
@FarhanAhmed We use the latest version of PBI desktop. Trying to Get Data -> SQL Server.
There's no doubt the user has all needed permissions to SQL DB because when I run PBI desktop as Administartor and we authetificate using "alternative credentials" and enter user's credentials, everything works properly. But when user runs PBI desktop in usual way he gets this error just after he clicks Get Data -> SQL Server.
This is very known issue when using Alternate Credentials. Microsoft itself recommend it to open it using "Run As Administrator." Unfortunately whenever you will try to add new table in your model, you need to do it same.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-error-launching-desktop
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
82 | |
72 |