powerbi - Remove all HTML tags from column present Dataset in Power BI -

here query regarding text formatting inside column value.

the scenario is

i have 1 power bi data set html tags present in it. remove html tags column value , keep plain text.

below example better understanding - column1 = "

<ul style="margin-top:0in;margin-bottom:0in;margin-left:0.375in;unicode-bidi:embed;direction:ltr;"></ul></ul><p> number of products sold</p><p>2000</p><p>this month of january</p> 

"

now required formatted text should -

number of products sold 2000 month of january

---

i heard can power query don't have knowledge regarding same, can guide me?

you can use this:

= web.page("your html text") 

make sure escape " characters ""