Get HTML code in textfile into 1 row in data model

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