Unicode in Power BI table

[P0werBIn00b]

Hello all,

I was trying to load data as unicode from a power query. However, the data in the column that I extracted from the source was not in Unicode, but something like below as text:

s}nfnL

?kGb]xL

It is stored like that in the source database. Maybe cause I don't have Unicode installed in the database or something. But in power BI, I want to show it as Unicode. How can I do that? Is there a way to change text like that into Unicode using the power BI query editor?

Thanks in advance!!!

[Anonymous]

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

[kimjaehe]

thank you 😀

[pratyashasamal]

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