When your queries return Long Description fields containing HTML markers, you can quickly convert the fields to plain text in Power BI Desktop. This article explains how to add a custom column and remove the markers.

This example query fetches assets with long description fields:

mnt.assets?$select=ObjectID,LongDescription

To convert HTML to plain text:

1. In the Power Query Editor window, select the Add Column
2. Click Custom Column to open the Custom Column dialog.
3. Give the column a name, for example, “LongDescriptionPlainText”.
4. Enter the following formula:

try (Html.Table([LongDescription], {{"text",":root"}})) otherwise null

5. Click OK.
6. Expand the new column and click OK.