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.
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
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.
I need help about this message too
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)'"
Any one found solution for this? Please to needful
Did you try the OBDC connection already?
Any one found solution for this?
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)'
We had issues with the standard PostgresSQL connector and used ODBC instead. Check this link.
Thanks Aron, i will try this and report back
Hi JR,
I have the same issue now. Did you have a solution for the issue?
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.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |