Display text without HTML code, but with formatting

[Anonymous]

Hi,

I loaded the data from the Sharepoint list into Power BI. The text fields were in HTML format. E.g.
<div class = "ExternalClassDB4D9 ....."> <div> <div> Q1 <br> ....
To remove the HTML code, I used the FieldValuesAsText function, but got plain text. All text formatting is gone. There is a lot of text, so it has to be displayed from new lines somewhere and so on.
Is it possible to leave HTML code that preserves formatting but display in a dashboard without HTML code? Text only?

[Anonymous · Accepted solution]

Currently Power BI does support Rich text field. Just change the data type of field to plain text in Sharepoint itself.

Other way is you can use HTML content custom visual, but it does not support export to pdf or ppt format.