Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I loaded the data from the Sharepoint list into Power BI. The text fields were in HTML format. E.g.
<div class = "ExternalClassDB4D9 ....."> <div> <div> Q1 <br> ....
To remove the HTML code, I used the FieldValuesAsText function, but got plain text. All text formatting is gone. There is a lot of text, so it has to be displayed from new lines somewhere and so on.
Is it possible to leave HTML code that preserves formatting but display in a dashboard without HTML code? Text only?
Solved! Go to Solution.
Currently Power BI does support Rich text field. Just change the data type of field to plain text in Sharepoint itself.
Other way is you can use HTML content custom visual, but it does not support export to pdf or ppt format.
Currently Power BI does support Rich text field. Just change the data type of field to plain text in Sharepoint itself.
Other way is you can use HTML content custom visual, but it does not support export to pdf or ppt format.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |