Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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....
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
@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
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
yes...already i am using.
SET client_encoding TO 'UTF8';
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
)
User | Count |
---|---|
92 | |
86 | |
78 | |
72 | |
65 |
User | Count |
---|---|
115 | |
107 | |
86 | |
65 | |
64 |