special characters is replace with other character

[nisha_deepak]

i have one column named name_insured which is text type data.In database value of that field is like Water- Edge Townhomes.

but when i load data from database to power bi that value is changed to Water’s Edge Townhomes. some special character is showing instead of hypen(-).i need hypen itself in my report ..how can i get that?plse help....

[v-yingjl]

Hi @nisha_deepak ,

Could not reproduce it in my environment. Which database you are using and what is the specific data type of this column in the database? Could you please consider sharing more details about this issue for further discussion?

Best Regards,
Community Support Team _ Yingjie Li

[amitchandak]

@nisha_deepak , refer to these two

https://xlncad.com/remove-or-extract-special-characters-from-a-data-set-using-power-query/

https://stackoverflow.com/questions/52860218/replacing-a-special-character-in-power-bi

[themistoklis]

@nisha_deepak 

It is encoding issue.

When you load the data make sure you use UTF-8

https://community.powerbi.com/t5/Desktop/Making-result-come-in-UTF-8/td-p/873316

[nisha_deepak]

yes...already i am using.

SET client_encoding TO 'UTF8';

[themistoklis]

@nisha_deepak 

Have you tried the following function in Power Query

TextEncoding.Utf8

let
    texto = "abcde",
    texto_binario = Text.ToBinary(
        texto,
        TextEncoding.Utf8
    )
in
    Binary.ToList(
        texto_binario
    )