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

 

Hi P0werBIn00b ,
You may have used the UNICHAR() or UNICODE()

function in DAX to return Unicode characters in DAX measures.
You can refer to these links :-
https://datasavvy.me/2022/06/30/generating-unicode-characters-in-power-query/

https://learn.microsoft.com/en-us/dax/unicode-function-dax

https://learn.microsoft.com/en-us/dax/unichar-function-dax

https://www.dalesandro.net/how-to-use-unicode-characters-in-power-bi/

Hope this was helpful.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C