title: Convert HTML column to plain text in Power BI
body: <p>Power Bi imports (e.g. from Outlook calendar) some data with HTML tags.</p>
  <p>I need to remove these and the simplest method is to create a custom column using Html.Table</p>
  <pre><code>Html.Table([HTML text],{{&quot;Plain text&quot;,&quot;:root&quot;}})
  </code></pre>
  <p>where &quot;Plain text&quot; is the new column.</p>
  <p>This works fine, except if there are empty cells in the &quot;HTML text&quot; column. The first empty cell (null) causes an error:</p>
  <pre><code>&quot;We cannot convert the value null to type Text&quot;
  </code></pre>
  <p>And the conversion stops.</p>
  <p>Is there a condition that can be applied &quot;If null then null else&quot; to solve this error?</p>
  <p>Many thanks!</p>
  <p>P.S. I have seen @Alexis Olson thread <a href="https://stackoverflow.com/questions/62329169/convert-html-table-to-plain-text-in-power-bi">Convert HTML Table to plain Text in Power BI</a> but the Html.Table solution is simpler.</p>