'Text Area' field from Dataverse imported in Power BI via PowerQuery / it keeps all the formatting!

[AliceW]

Hello everyone,

So, I have this table in the Dataverse, and I have a text field, configured as 'Text Area', and with the Rich Text Editor option added, so that the users can make the text bold, highlight it, the works.

While that is fantastic in my Model-Driven PowerApps, it's less so in Power BI.

Namely, all the formatting is also present! Like &nbsp;</p><p style="margin: 0;">.

I've tried cutting stuff down, like extracting between values, but some are still there.

My question is: is there a way to do this once for the entire text? Convert it to plain?

Huge thanks in advance,

Alice

[AliceW · Accepted solution]

Update: found it!!

https://www.youtube.com/watch?v=4UDynnPQpG4