Forum Discussion

titanconsulting's avatar
titanconsulting
Frequent Visitor
3 years ago

Base64 to html conversion in power query

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?