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.
How to remove accents from a column using Power Query?
My column "descritivo" has a lot of accentuated characters, like:
"Á"
"õ"
"Ù"
...
I want:
"A"
"o"
"u"
How to do this?
Solved! Go to Solution.
Hi @webportal ,
You can do this by using R in Power Query.
Please check this link: http://datacornering.com/how-to-convert-accented-characters-to-unaccented-in-r-or-power-bi/
_______________
If I helped, please accept the solution and give kudos! 😀
Please try this: https://stackoverflow.com/q/71969831/6165594
= (textToConvert) =>
let
textBinary = Text.ToBinary (textToConvert, 1251 ),
textASCII = Text.FromBinary(textBinary , TextEncoding.Ascii)
in
textASCII
Simple, Quickly and Bealtiful...Congratulations
Very quick elegant solution, works for me, should be marked as the solution as well!
Hi @webportal ,
http://datacornering.com/how-to-convert-accented-characters-to-unaccented-in-r-or-power-bi/
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Sorry, a bit off topic...
But how did you attach .pbix file to post? 🤔
Here is the branch for this topic. 🙂
@webportal
You can use replace value in power query to do it one at a time like
For more values, follow this video that shows how to do it for bulk replacement.
https://www.youtube.com/watch?v=MLrRlPh_ZFQ
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @webportal ,
You can do this by using R in Power Query.
Please check this link: http://datacornering.com/how-to-convert-accented-characters-to-unaccented-in-r-or-power-bi/
_______________
If I helped, please accept the solution and give kudos! 😀
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |