Reply
Frequent Visitor
Posts: 5
Registered: ‎06-14-2018

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

Member
Posts: 100
Registered: ‎07-18-2017

Re: Error connecting to PostGresSQL db

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

Frequent Visitor
Posts: 5
Registered: ‎06-14-2018

Re: Error connecting to PostGresSQL db

Thanks Aron, i will try this and report back

Highlighted
Frequent Visitor
Posts: 4
Registered: ‎06-19-2018

Re: Error connecting to PostGresSQL db

Hi JR, 

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

Frequent Visitor
Posts: 5
Registered: ‎06-14-2018

Re: Error connecting to PostGresSQL db

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.

Frequent Visitor
Posts: 5
Registered: ‎05-07-2018

Re: Error connecting to PostGresSQL db

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)'

 

 

Frequent Visitor
Posts: 3
Registered: ‎06-28-2018

Re: Error connecting to PostGresSQL db

I need help about this message too Smiley Indifferent

Visitor
Posts: 1
Registered: ‎07-01-2018

Re: Error connecting to PostGresSQL db

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)'"

Frequent Visitor
Posts: 5
Registered: ‎06-14-2018

Re: Error connecting to PostGresSQL db

Did you try the OBDC connection already?

Frequent Visitor
Posts: 2
Registered: ‎07-18-2018

Re: Error connecting to PostGresSQL db

Any one found solution for this?