Unicode in Power BI table

Hi P0werBIn00b ,

You can use the Text.ToBinary and Text.FromBinary functions in a power query to convert text to binary and then back to text. This may help with special characters.

Refer to the following:

let
    Source = Excel.Workbook(File.Contents("C:** in Power BI table.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    AddTextColumn = Table.AddColumn(#"Promoted Headers", "Result", each Binary.ToText(Text.ToBinary([Value])))
in
    AddTextColumn

For more details,  you can read below document:

Text.FromBinary - PowerQuery M | Microsoft Learn

Text.ToBinary - PowerQuery M | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly