Change Encoding Settings in Power BI

[NWBI]

Hello All,

I am connected to a PostgreSQL Database on Huroku. I can connect succesfully, but upon loading the desired tables I get this error.

"DataSource.Error: ODBC: ERROR [22P05] ERROR: character with byte sequence 0xe2 0x80 0x8b in encoding "UTF8" has no equivalent in encoding "WIN1252";
Error while executing the query"

I understand that by changing the encoding settings in to UTF* the issue will stop, but I cannot find where to adjust the encoding settings.

Anyone now how?????

[v-jiascu-msft]

Hi @NWBI,

Where did you get this error message? Seems Power BI can handle this scenario in my test. 

Best Regards,

Dale

[jpzaragoza]

Hi All.

Using the postgres ODBC and configuring the connection in unicode mode on System DSN the issue is solved (PBI connection will be ODBC)

https://www.postgresql.org/ftp/odbc/versions/dll/

Regards.

Juan

[jpzaragoza]

Hi All.

Using the postgres ODBC and configuring the connection in unicode mode on System DSN the issue is solved (PBI connection will be ODBC)

https://www.postgresql.org/ftp/odbc/versions/dll/

Regards.

Juan

[LioriK]

I have the same issue, any solution to that???

[Greg_Deckler]

Hmm, some accessing data functions in Power Query support an encoding type (like CSV) but I do not see that for PostgresSQL:

https://msdn.microsoft.com/en-us/library/mt260869.aspx