Change HTML to Text

[AsantezaK]

I have Rich Text fields from SharePoint List (I need it for Power Apps form entries). The fields come to Power Bi reports from the SharePoint Lists as HTML code. Any way to display them as Text in Power Bi?

[lbendlin]

Do you want to parse the HTML, or do you want to strip the tags and keep the text?

[AsantezaK]

Parsing the HTML would be ideal, if possible.

Else, striping the tags to keep text.

[lbendlin · Accepted solution]

in Power Query use Html.Table - PowerQuery M | Microsoft Learn with the parsing instructions.

In Power BI you could consider using one of the HTML viewer visuals. I would recommend HTML 5 Viewer Lite.