Remove Accents from Text in Power Query M

Replaces accented characters (é, ü, ñ, etc.) with their plain ASCII equivalents.

Text TransformationsIntermediateaccentsdiacriticstextascii

Power Query M code

let
    Source = YourTable,
    From = "áàâäãåéèêëíìîïóòôöõúùûüçñÁÀÂÄÃÅÉÈÊËÍÌÎÏÓÒÔÖÕÚÙÛÜÇÑ",
    To = "aaaaaaeeeeiiiiooooouuuucnAAAAAAEEEEIIIIOOOOOUUUUCN",
    Cleaned = Table.TransformColumns(Source, {{"ColumnName", each Text.Combine(List.Transform(Text.ToList(_), each let p = Text.PositionOf(From, _) in if p = -1 then _ else Text.At(To, p)), ""), type text}})
in
    Cleaned

Notes

Extend the From/To pairs if your data uses accented characters not listed here.

Requirements

A table with a text column containing accented characters.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Remove Accents from Text.