Get HTML code in textfile into 1 row in data model

[TheKnall]

Hi

I have a text file that I have loaded into Power BI. The text file contains a HTML code. 

When loaded into Power BI the text is devided into seperate rows. I want to use the html code in the custom visual.
But need all code in the same row, not devided by some sort of delimiter.

Here is some of the the HTML code:
<p class="ql-align-center"><strong>Activity Ratio</strong></p>
<p>&nbsp;</p>
<p><strong>What is it?</strong></p>
<p>This category is intended to measure how well a company manages various activities, particularly how efficiently it manages its various assets.</p>
<p>&nbsp;</p>
<p><strong>Why is it important?</strong></p>
<p>The ratios give an indication of ongoing operational performance- how effectively assets are used by the company.</p>

any tips on how to handle this with a clean approach, without doing many transformation steps ?

Thx!

[v-danhe-msft · Accepted solution]

Hi @TheKnall ,

Based on my test, you could use below functions:

In query editor, you could use text.combine function(https://docs.microsoft.com/en-us/powerquery-m/text-combine😞

let
    Query1 = Text.Combine(#"Table1"[Column1]),
    #"Converted to List" = {Query1},
    #"Converted to Table" = Table.FromList(#"Converted to List", Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    #"Converted to Table"

Result:

In dax, you could use CONCATENATEX function:

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax

CONCATENATEX = CONCATENATEX('Table1','Table1'[Column1])

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He