Forum Discussion

JR2018's avatar
JR2018
New Member
8 years ago

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 ...
JR2018's avatar
JR2018
New Member
8 years ago

Thanks Aron, i will try this and report back

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi JR, 

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

  • JR2018's avatar
    JR2018
    New Member
    8 years ago

    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.