Forum Discussion
Error connecting to PostGresSQL db
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
12 Replies
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)'
I need help about this message too :smileyindifferent:
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)'"
Did you try the OBDC connection already?
I solved it by installing Npgsql-3.2.7. Versions above 4 are incompatible
This worked for me thanks. Just had to uninstall all the other versions, restart my server/client.
Install 3.2.7.
We had issues with the standard PostgresSQL connector and used ODBC instead. Check this link.
Thanks Aron, i will try this and report back
