special character showing issue while fetch from postgresql database to power bi desktop

[nisha_deepak]

i am  creating a report in desktop using data taken from postgresql database.I use postgres odbc driver .

while fetching data using select query i try like this.

After loading data from db to power bi desktop some of the data is not correctly showing like in database.Some data is showing like special characters.But the problem is some of the same value having issues ...some of the same data is not having any issue.

MY database column is like this.

But same thing is showing differntly in powerbi

here 2 value in column is entirely different compare with data from database .These type of lot of data having issue.

Plse give some suggestions.

[V-pazhen-msft · Accepted solution]

@nisha_deepak 

This " - “ might be unsupported characters in power bi if it is recorded using input method of other languages. Try replace " - “ with the same "-" enter by "English(United States)". Or just replace "-" to other characters e.g. ">" or "@".

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[V-pazhen-msft]

@nisha_deepak 

What is the datatype of the columns in your DB, and what does it become when  loaded into power bi?

Paul

[nisha_deepak]

In Db and power bi column is text daattype