Forum Discussion

P0werBIn00b's avatar
P0werBIn00b
Icon for Helper I rankHelper I
2 years ago

Unicode in Power BI table

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 ...
Need Help
Show and Tell
pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
2 years ago

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