Forum Discussion

sardo's avatar
sardo
Regular Visitor
2 years ago

Convert HTML column to plain/formatted text in Power BI

I need to conver HTML column in plain text. I've watched some tutorials and added a custom column with the following coding in Power Query: Html.Table([HTML text],{{"Plain text",":root"}}) This does...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sardo 

 

Can you provide some dummy data to show what you want to achieve? Perhaps you want to extract a table between <table> tags from the HTML code? Or perhaps you want to remove all tags in some HTML code? Do you have HTML code in the [HTML text] column or have a html file in this column?

 

Best Regards,
Jing

  • sardo's avatar
    sardo
    Regular Visitor
    2 years ago

    Hi Jing,

    I'm connected to Salesforce Object and this is an HTML field.

    When I use the HTML Content Custom Visual, it shows me the data correctly with the right formatting, but I can't add any more fields and I need the content to be used in a Table. 

    I successfully added a custom column in Power Query by using the Html.Table([HTML text],{{"Plain text",":root"}}) code, but it's a plain text and hard for the customer to read.

     

     

     

    Hope this clarifies. Thank you.