Not even sure how to describe issue.

[Tuna357]

We recently started pulling data into a table and the output is less than helpful.  

Would anyone knows what needs to be done here in order to correct?  Or if it's even possible?

Thank you!

[Tuna357 · Accepted solution]

I ended up finding this video on Youtube and it worked flawlessly:

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

[danextian]

If you look at the code in my screenshot, it's just the same ":root". The difference is in the name of the column being referenced.

[danextian]

hi @Tuna357 

Seems like you are pulling the html code itself instead of the actual text as you would see in a browser.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wiik1MDBOLgBTqSEZmcUKQAQRLC4pys9Lh8gUJ+YW5KRCxPWRJRQ8Qnx9FEpSK0r0oLJQs1AMdszLL8lILVLIycxLVchPw6ZeKVYnWsnHM8zTz13BPzREwd9NwdnRN8A1SCk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [text = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"text", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Data", each //parse the text from the html only
//will return one or more rows
//combine into a sing text string
Text.Combine(Html.Table([text], {{"Content", ":root"}})[Content], " "))
in
    #"Added Custom"