Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
walker21
Frequent Visitor

Remove HTML Tags from Column with Null Values

How do I extract the plain text from columns in HTML and exclude null values? I have a column that has a mix of plain text, HTML, and null values.

I tried using "Html.Table([ColumnName] , {{"text",":root"}})" but when it hits a null value, it breaks everything. 

 

walker21_0-1675792475043.png

 

 

2 REPLIES 2
Chatticha
New Member

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

sinigagliafeder
Frequent Visitor

Hello @walker21 ,
I don't know if you still need assistance but I have a workaround if you need.
Simply replace the null value with NA in the column and then create another column using this formula "Html.Table([ColumnName] , {{"text",":root"}})". 

In this way you will not get the error message 😉

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.