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 all,
I am trying to make a connection with Power BI Destop to a local SQL server.
When I choice the SQL server and the database I got this message:
Can not load the file or assembly System.Transactions, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = b77a5c561934e089 or one of its dependencies. The required impersonation level was not provided or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)
Kan bestand of assembly System.Transactions, version=4.0.0.0, culture=neutral, PublicKeytoken=b77a5c561934e089 of een van de afhankelijkheden hiervan niet laden. Het vereiste imitatieniveau is niet geleverd of het geleverde imitatieniveau is ongeldig. (Uitzondering van HRESULT:0x80070542)
It looks like a .NET error.
Could someone give me advice?
Thanks you in advance.
Kind regards
Louis van Paassen
Hmm...do you have any changes on your current user that prevents your from impersonation?
Check "Local Security Policy"->Local Policy-> User rights assignment->Impersonate a client after authentication
Are you using Personal Gateway, or trying to connect from just within the Desktop client?
http://blogs.msdn.com/b/powerbi/archive/2015/07/07/refresh-for-on-premises-sources-is-here.aspx
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |