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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Remove HTML tags from columns

Hello,

I want to remove the HTML tags from my text columns, I tried multiple solutions on the community forum but even when I get something working I get an error in my custom column. The error is "Cannot convert a value of type Record to type Text".

 

bloody87_0-1672069427838.png

 

I tried this:

 

Text.Clean(
Text.Trim(

if Text.Contains([[ALL.achievements_last_week]], "<")
then Text.BeforeDelimiter([[ALL.achievements_last_week]], "<")
else
[[ALL.achievements_last_week]])
)

 

and

 

=Html.Table([ALL.achievements_last_week], {{"ExtractedText",":root"}})

 

 

I still get the error "Cannot convert a value of type Record to type Text"

 

1 ACCEPTED SOLUTION
AlB
Community Champion
Community Champion

@Anonymous 

You were almost there. I believe there's only a simple error in your code for the custom column. You had:

 

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

 

 with  [[Column1]] where you only need one set of [ ]:

 

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

 

That is why PQ was interpreting as a record

See it at work in the attached file (Table1, I've left your original query untouched)

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

View solution in original post

9 REPLIES 9
Sang10
Regular Visitor

Anyone know how to get rid of the errors for the nulls, I can't remove the errors as there is other info attached to that row

Anonymous
Not applicable

Background: ADO > Boards SVC > Query > "Open in Power BI" Extension. All the custom fields are exporting as HTML. After performing the aforementioned guidance, which partially works in my case, the null fields are causing Errors. Any advice on a best way to remove Nulls or ignore them? 

mhannah77_0-1698686982524.png

 

I found that using an if statement to only apply Html.Table to non-null values did the trick when expanding the column.

 

e.g. 

 

if 
[Column1] = null 
then null 
else Html.Table([Column1], {{"ExtractedText",":root"}})

 

Mahesh0016
Super User
Super User

@Anonymous ,

Mahesh0016_0-1672123863054.png

>> If this post helps, please consider accept as solution to help other members find it more quickly.

AlB
Community Champion
Community Champion

Hi @Anonymous 

Can you share the query or, ideally, a pbix reproducing the error?

 

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

Anonymous
Not applicable

Hi @AlB Please find the example pbix

 

https://we.tl/t-d4G1yq5Qw7 

 

One note I also tried the "HTML Content" visual but its not working with it as well.

AlB
Community Champion
Community Champion

@Anonymous 

You were almost there. I believe there's only a simple error in your code for the custom column. You had:

 

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

 

 with  [[Column1]] where you only need one set of [ ]:

 

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

 

That is why PQ was interpreting as a record

See it at work in the attached file (Table1, I've left your original query untouched)

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

Anonymous
Not applicable

Thank you @AlB That did the trick. Didnt notice the second pair of [ ] 🙂 

@Anonymous 

Mahesh0016_0-1672133470852.pngMahesh0016_1-1672133496119.png

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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