Extract Plain Text From SharePoint Rich Textbox Field In Power BI

In this article, we will talk about how we can extract only text values from the enhanced Rich textbox field from the SharePoint list to 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 to 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”.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Step 2
 
Now, let’s load the list to the Power BI. Click on Load.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Step 3
 
The fields have been loaded into the report. Now, drag the column title and description in the table.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Here, you can see Power BI loaded HTML tags in the table.
 
Step 4
 
To overcome that situation, from the ribbon, select Edit Queries.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Step 5
 
When we load the data to the Power BI, SharePoint adds one column named “FieldValuesAsText”.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Expand that column.
 
Step 6
 
From “FieldValuesAsText”, expand the column “Description” and click on OK button.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Step 7
 
This will extract the plain text from the HTML text. You can see the following result.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Step 8
 
Click on Close and Apply.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
Step 9
 
Drag the columns in the table. Drag “FieldValueAstext.description”.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 
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.
 
Extract Plain Text From SharePoint Rich Textbox Field In Power BI
 

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!!