How can Power BI keep the rich text formatting in Excel

[SDdong]

Anyone have idea on how to keep the rich text formatting in excel and show exactly same in Power BI? TIA

[Anonymous · Accepted solution]

Hi @SDdong ,

As far as I know, this is due to the design of Power BI. 

You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

You can use the following method instead:

1.Please create custom coumn and use this code , and enjoy

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

2.Please use a custom visual object. HTML Content (microsoft.com)

Best Regards,

Neeko Tang

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

[rajendraongole1]

Hi @SDdong -Power BI itself doesn't support rich text natively.

workaround solved link:

Solved: Enhanced Rich Text to show in Power BI Report - Microsoft Fabric Community

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[SDdong]

Thanks for your reply. but for my case, the data is not from sharepoint list, it is from excel.

need to find a solution to get the rich text format in excel cell and load it into power bi.