System.Transactions

[louisvp]

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

[pqian]

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

[ALeef]

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