Convert HTML to formatted text in Power Query

Показать описание

Let me show you how to convert html on a power query column into formatted text.

Join this channel membership to get access to all the recorded bites as they become available:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen

#CURBAL #SUBSCRIBE

Рекомендации по теме

Комментарии

You are an absolute genius. I saw a question below about combining if you have multiple levels, but think I can figure the rest of that out thanks to your amazing video.

TravisUrban

I somehow managed to extract the text formatted as HTML for one of my reports- and I was happy with it. And now, I am even happier :D Thank you!

a_visualcue

This is exactly what I needed, explained clearly and simply. Many thanks.

HIGHLNDER

Hello, I used your method and it worked with PBI desktop. However, when uploading to PBI service, it said PBI block HTML code and I cannot refresh it online. Do you know how to fix it please?

MaiNguyen-qi

Excellent. So simple and yet so effective. Thanks. You solved my problem in no time.

saurabhkejriwal

Hi, thanks for this wonderful content.
In the below source data, multiple tags added in between the same line of text. And these single lines of text are showing up in multiple text columns after expanding in power query. Any solution for this.

jithiljohn

If I do this, it would not make links clickable right? It only keeps simple text with proper visual order?

notorioussamurai

Thank you!! 😭 🤌🏽 This video saved me so much time and sped up my reports 🏃🏾‍♂️💨

antwanwright

Hello, Thanks for this. but Its showing an error on me. any idea? It says the following: "[Expression.Error] The import Web.Page matches no exports. Did you miss a module True
isExpected: True"

raxmalayte

That's neat, thanks for sharing the video!

MrAszpic

Hi, i have a problem. İ wrote the code on power query but when i click the right button, i saw error. This error: no column were found and i could not expand data. Can you help me?

mahinurgungor

I was hoping that this would work for me but I am currently at Text.72 and the Children column is still letting me expand. I don't think there have been any additional rows in a while... Do some websites not end or do I just have to persevere?

BlueGlowingLight

You have text only in text 3. How ever in other scenarios, we may have text all children text fields. How do we combine all ? Please assit

montecarlo

Convert HTML to **formatted** text in Power Query