How to fix characters like this "ñ"

[Anonymous]

Hi, I have some CVS files with this format :

ñ (the original is "ñ")

ó (the original is "ó")

í (the original is "í")

I think I may have to change the code to something that can traduce this into Spanish characters. I have tried the Latin ones but without good results.

Any clue ?

Thanks a lot.

[amitchandak · Accepted solution]

@Anonymous , Check the encoding setting. And refer to steps given in this topic to choose the correct one

https://community.powerbi.com/t5/Power-Query/How-to-set-the-csv-file-encoding/td-p/194805

[Anonymous]

"65001: Unicode (UTF-8" works for Spanish characters, thanks!