Base64 to html conversion in power query

[titanconsulting]

As the title suggests - I need to convert a field from base64 to html.  I'll then use the HTML viewer to display the fields in the table.

I'm trying two different things (both sourced from the internet)

Lines.FromBinary(Binary.FromText([StatusTxt],BinaryEncoding.Base64), null, null, 1252){0}

This is succefully changing to HTML, but for some reason, it's only coding the first paragraph and then stops??   I can tell this in the raw data in HTML format as well as when I put it in the HTML viewer visual.

Binary.Decompress(Binary.FromText([StatusTxt], BinaryEncoding.Base64))

This gives me the error on every row 'Expression.Error: The key matched more than one row in the table.'

What am I doing wrong?

[Anonymous]

Hi @titanconsulting,

Can you please share some dummy data that keep the raw data structure? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng