The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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! 😀
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |