I'm new to "M" and I have a question that I think should be pretty simple but I can't find the right answer anywhere.
I am connected to a SharePoint List through Power BI and a few of the columns in the data set are coming across like this:
I changed the text to "X's" for confidentiality. Anyway, How can I remove all the HTML script from all these columns and rows so that it just gives me the comments? I can't find anything about how to remove this from the entire data set so I'm hoping someone here can help.
I also have a column or two with
<?xml> tags too, but should also only show the comments between the