@Anonymous
Pasted your sample HTML data in PQ using ENTER DATA table option, you can import from your HTML file as Web source.
So the data looks like this
The Added a custom column with following code
=Html.Table([Column1], {{"ExtractedText",":root"}})
Then Expanded the New Column, you get only the text
If you want to combine al the above lines into one CELL, add the following line:
=Text.Combine(#"Expanded Custom"[ExtractedText],"#(lf)")
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
@Fowmy That's awesome, thanks for the advice.
I've also discovered the custom Visual HTML Content, which displays HTML Rich text in their natural/intended form. Also works really nicely.
@Anonymous
Pasted your sample HTML data in PQ using ENTER DATA table option, you can import from your HTML file as Web source.
So the data looks like this
The Added a custom column with following code
=Html.Table([Column1], {{"ExtractedText",":root"}})
Then Expanded the New Column, you get only the text
If you want to combine al the above lines into one CELL, add the following line:
=Text.Combine(#"Expanded Custom"[ExtractedText],"#(lf)")
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
@Fowmy That's awesome, thanks for the advice.
I've also discovered the custom Visual HTML Content, which displays HTML Rich text in their natural/intended form. Also works really nicely.
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
