Get HTML code in textfile into 1 row in data model

Question

HiI have a text file that I have loaded into Power BI. The text file contains a HTML code.&nbsp;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:&lt;p class="ql-align-center"&gt;&lt;strong&gt;Activity Ratio&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;What is it?&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;This category is intended to measure how well a company manages various activities, particularly how efficiently it manages its various assets.&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;Why is it important?&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;The ratios give an indication of ongoing operational performance- how effectively assets are used by the company.&lt;/p&gt;any tips on how to handle this with a clean approach, without doing many transformation steps ?Thx!

v-danhe-msft · Accepted Answer

Hi&nbsp;TheKnall&nbsp;,
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&nbsp;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.
&nbsp;
Regards,
Daniel He
&nbsp;
&nbsp;

Forum Discussion

Get HTML code in textfile into 1 row in data model

1 Reply

Related content

Retrieving data via HTML

Waterfall by HTML Help

Convert HTML files to PDF

PDF Export Missing HTML Table Content

HTML Content