How to use the Html.Table function to add a column that converts a HTML column into plain text

Hi pruvieros ,

Yes, please try

Html.Table([Column1.1] , {{"text",":root"}})

You can also deal with error by usng try ... otherwise like so

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

So if you encounter an error at this point, Power Query will just return null and the query won't stop at this step. 

Reference: Solved: Convert HTML to Text - Microsoft Power BI Community

Convert Data From HTML To Plain Text In Power BI (c-sharpcorner.com)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.