Forum Discussion
Change HTML to Text
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?
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.
3 Replies
Do you want to parse the HTML, or do you want to strip the tags and keep the text?
Parsing the HTML would be ideal, if possible.
Else, striping the tags to keep text.
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.
