Forum Discussion

Domenick's avatar
Domenick
Helper IV
6 years ago

Removing HTML Markup from field

One of the fields in my table includes HTML. Is there an easy way to prevent those tags from appearing when I populate this data into a data table?

7 Replies

  • Domenick 

    In Power Query, you can remove (delete)  that particular column prior to close and load to your data model. 

    Columns deleted in this way can be called again if necessary.

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

    • Domenick's avatar
      Domenick
      Helper IV

      I actually do need that data. I just need to remove the HTML tags so that it is clean.

      • Fowmy's avatar
        Fowmy
        Super User

        Domenick 

        Can you provide some sample data?

        ________________________

        Did I answer your question? Mark this post as a solution, this will help others!.

        Click on the Thumbs-Up icon on the right if you like this reply 🙂

        YouTube, LinkedIn

    • parry2k's avatar
      parry2k
      Super User

      Domenick check if this post helps.

       

      I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

       

    • Domenick's avatar
      Domenick
      Helper IV

      Cool. Is it still accessible? Any ideas on how to get a table to read HTML?