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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Rich text/HTML formatting in PowerBI table

Hi all, 

 

I currently have an important that comes with HTML mark-up due to how it is input into a database; so lots of <p> and <b> and a huge chunk of text that is generally unreadable. 

 

Is there a way to either:

  • Strip out all HTML mark-up
  • Apply the HTML formatting as a part of the table (this would be a preference)

I can alter the data via an excel export (as it's not a 'live' report), but not the direct source.

 

Thanks!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

4 REPLIES 4
blodus
Advocate II
Advocate II

Apparently, the Real Answer is NO - Power BI is incapable of rendering HTML. How ridiculous. I work in a real company and can't use unsupported, user-made objects to make up for PBIs lameness.

amitchandak
Super User
Super User

@Anonymous , You have HTML content , no sure if that can help

HTML content
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001930?tab=overview

Please create custom coumn and use this code , and enjoy

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

This worked for me, thanks!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.