Error connecting to PostGresSQL db

[JR2018]

Hi there, 

I have searched the preexisting threads related to PostGres connections but have not found one with the same issue. When I open Power BI desktop, i click Get Data and then i select the PostGresSQL database option and enter the Server Name and Database name. I then get the error below. 

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.ValueTuple, Version=4.0.3.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.'"

Any advice on this would be appreciated. 
THanks

[Diogo]

I solved it by installing Npgsql-3.2.7. Versions above 4 are incompatible

[Batshell]

This worked for me thanks. Just had to uninstall all the other versions, restart my server/client.
Install 3.2.7.

[Diogo]

I need help about this message too 

[sujanp]

Even I am facing the same issue.

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.ValueTuple, Version=4.0.3.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'"

[Madhu234_EEE]

Any one found solution for this? Please to needful

[JR2018]

Did you try the OBDC connection already?

[Madhu234_EEE]

Any one found solution for this?

[Anonymous]

Potentially the same issue here, do we have anyone able to lend a hand? Thanks!

'Could not load file or assembly 'System.ValueTuple, Version=4.0.3.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'

[Aron_Moore]

We had issues with the standard PostgresSQL connector and used ODBC instead. Check this link.

[JR2018]

Thanks Aron, i will try this and report back

[Anonymous]

Hi JR, 

I have the same issue now. Did you have a solution for the issue?

[JR2018]

So we tried the odbc connection and it worked in terms of connecting to the DB however when we tried to query the tables in the DB we got the following error 

DataSource.Error: ODBC: ERROR [HYOOO][Devart][ODBC][PostgresSQL]character with byte sequence 0xa5 in encoding "UTF8" has no equivalent in encoding "WIN1252"

So we made some progress but not there yet. Going to try and figure this out now.