Convert data from HTML to Plain Text using Power Query for Power BI Table Visualization

As we all know, Power BI table visualization does not support HTML generation. So, we need to convert our HTML text to Plain text.

With the help of Power Query function, we can easily remove HTML tags from the Text in Power Query. To implement that we need to use function HTML.table() in Power Query.

In this session, I am going to demonstrate this procedure step by step with you.

#PowerBI
#PowerQuery
#PowerBITip

[nikoskenderis]

I never comment on videos, but this video solved a problem of mine at work, so I thought I should thank you!

[pablofabiocabrera]

Than you Dhruvin Shah! Very straightforward!

[thermant]

It's crazy how I googled this, then Google showed it to me on the front page. They placed me right where I needed to be in the video.
But when I finished it, I couldn't give a thumbs up. I had to click the title of the video so I could get to YouTube where I was able to give it the thumbs up.
What the hell is Google doing? They're shorting the creators on their own platform!!

Besides that, Thanks for the help! No way I was going to figure this out on my own.

[christianlira]

Hi Dhurivnand thank you for producing this video. Much appreciated.

[chriseales]

Awesome video, thanks very much for sharing.

[teknobear]

Very clear instructions. Thank you for posting!

[rodrigolbrigante]

Thank you! It was very straightforward, simple and solved my problem! Keep up with the great work!

[tateburgess]

Wonderful solution to my problem - question, how would you handle nulls in my HTML column? I get errors on those rows with nulls

[anilkumarpinakapani]

Very helpful, saved my day. Thank you.

[aynellrodriguez]

Thank you for this video. It was very easy to follow and I could solve a problem at work. Thanks!!

[richarddiasribeiro]

that was excactly what I was looking for. thank you so, so much!!!

[melissamcguinness]

do you have a video that shows this from start to finish, I'm new to this platform and need to know how to even get to this point.

[sitaramakella]

Thanks for this technique. But How could we apply this in Direct Query Mode ?

[jyothirmaivagvala]

Hi, small request... plz keep all the vedios of power bi like a folder at one place

[mdmazherali]

Nice Explaination. However, this solution does not work when using DirectQuery. Is there a workaround when using DirectQuery

[charlesjohnston]

Great little video, thank you! Works very well except if some cells in the HTML column only contain HTML without text - then this gives an error "We cannot convert the value null to type Text". Is there a condition that can be added to avoid this?

[mahinurgungor]

Hi, i have a problem. İ wrote the code 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?

[RahulDas-osrg]

Sir kindly make a video on implementation of RLS while embedding the powerbi report with custom web application.

[swapnilamundra]

Can you make a video on how to extract tables from the html column coming from SQLserver?

[daleramsawak]

I get an error because my HTML Column also has null rows, how can this be fixed?