Extract Plain Text From SharePoint Rich Textbox Field In Power BI

Overview

Sometimes, there is a situation where we have so many multiline textboxes in our SharePoint list and when we load those fields in our Power BI report it shows HTML with the text element. If we need to represent that HTML data in our Power BI table visualization, then it will print HTML in the table’s column. In order to overcome that scenario, we can show plain text and remove HTML text from the field.

In this article, we will check step by step how we can easily remove HTML from an enhanced Rich text field in Power BI.

So, now let’s get started!

Step 1. We have the list named “Medical”. We have one enhanced rich textbox column named “Description”.

Step 2. Now, let’s load the list to the Power BI. Click on Load.

Step 3. The fields have been loaded into the report. Now, drag the column title and description in the table.

Here, you can see Power BI loaded HTML tags in the table.

Step 4. To overcome that situation, from the ribbon, select Edit Queries.

Step 5. When we load the data to the Power BI, SharePoint adds one column named “FieldValuesAsText”.

Expand that column.

Step 6. From “FieldValuesAsText”, expand the column “Description” and click on OK button.

Step 7. This will extract the plain text from the HTML text. You can see the following result.

Step 8. Click on Close and Apply.

Step 9. Drag the columns in the table. Drag “FieldValueAstext.description”.

You can see, now the table shows us the value of the Description column in form of Plain text.

Below is a comparison of both columns.

Conclusion

This is how we can easily convert Rich Textbox field value to Plain Text. Isn’t it amazing?

Stay connected with me for the amazing articles!!

Happy Reporting!!