Enhanced Rich Text to show in Power BI Report

[Anonymous]

Dear Community,

I'm connecting to Sharepoint in Power BI Desktop, the data is coming from text box having data type 

Enhanced rich text (Rich text with pictures, tables, and hyperlinks), but when I import it in Power BI it is coming in HTML format. All though I'm able to achieve plain text via M code below:
Html.Table([#"Remarks"] , {{"text",":root"}})
But whitespace are not coming properly.
Can you please help me out to achieve enhanced rich text in Power BI such that if any text is bold or underling or italic, so it can appear in same format

Thanks in advance.

[gdine]

It helps... since publshing in PBI services and exporting it into PDF, the for HTML content view will not support it due to non-certitfed visual. 

please share your insights

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, here’s a custom visual that allows you to use the rich text formatting in the Power BI called HTML Content:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001930?tab=Overview

What’s more, here’s a blog that discusses several ways to deal with the rich text data fields in the SharePoint using the Power query, you can also take a look:

https://whitepages.unlimitedviz.com/2018/04/power-bi-report-rich-text-sharepoint/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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