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