Forum Discussion

datajjw's avatar
datajjw
New Member
4 years ago

Special characters not displaying. Looks corrct in Power Query but not in Data or Report views.

Hi   I have a problem with displaying macrons in New Zaland place names   I have folloowed advice in other posts. I am getting data form a CSV encoded as UTF-8.   in Power Query, macrons disply...
Need Help
datajjw's avatar
datajjw
New Member
4 years ago

Have managed to solve it by doing a manual replace in the power query

= Table.ReplaceValue(#"Replaced Value","ō#(008D)","ō",Replacer.ReplaceText,{"Teritorial Authority / Local Board"})

 

Does anyone have an automatic solution rather than having to do it every time I load a file with macrons?

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi datajjw 

     

    I cannot reproduce this. Can you please provide a sample csv file with some dummy data that can reproduce this problem? 

     

    Best Regards,
    Community Support Team _ Jing