text column not correctly encoding

[nisha_deepak]

I am using some of text type column from postgresql database for creating report in power bi.After loading data to power bi some of the values in column having some misamatch while comapare that value with database value.

Example...if i have columnin database  named  address which is having  value like this in School District - Westridge.

But ,when i load these column to power bi by connecting to database  its value changed to School District – Westridge.

these just an example,lot of values having issues...some value is convereted to  like this..– .Some are convereted to some other special characters.Issue is while fetching data from db and after loading to power bi..So i can't do anything after getting data to power bi...Also, i can't do replace value function in power bi because we can't predict whicha are the values changed to which special characters.Am using Set client_encoding to 'UTF-8'; . In query part...plse help?

[v-easonf-msft · Accepted solution]

Hi, @nisha_deepak 

Could you please tell me whether your problem has been solved?

Here is the same discussion on how to encode files to make Power BI display normally.

You  can check if   @Anonymous  's  solution in this  thread  works for you.

Best Regards,
Community Support Team _ Eason

[PhilipTreacy]

Hi @nisha_deepak 

Try leaving out the set client_encoding to 'UTF-8'

Phil