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 ...
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.