Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


convert HTML special characters

Is there an easy way to convert special characters encoded for html to standard characters. I'm receiving characters such as "&lt;" that i want to convert to "<" or "&#233;" that I want to convert to "é".

Super User
Super User

You'll find some links for html-cleanup here:


If you have a custom table of values to replace/translate, this might be better:


Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Thx for the reply Imke.


I found the links above but the first set is not really solving my issue because I don't really need to remove some html tags from a string, my concern is jut for special characters (and don't want to remove them, just to convert them).


I know Chris' pattern for this kind of replacement but just wanted to check if someone add a better solution than building a conversion table/function for this specific case. Sounds not, will use this trick but also post an idea for Microsoft to request for a native support of an Html.Decode function.

Hi @Seddryck,


In my opinion, programming language is more suitable to deal with these scenario, you can write an api to convert these characters, then use power bi get the result data.


I agree with ImkeF's point of view, you can write a custom function to replace the specify of characters.


BTW, I haven't found any functions to format special HTML characters. 



Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors