Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Korean text is not allowed in Making Custom Column action

When type Korean text in making new custom column action,

Pop-up error message...

 

It seems that an error has occurred for over a year, but it still hasn't been fixed.

This error makes me reluctant to use Power BI.

I'm transferring text to Notepad and using copy-paste, but it's really inconvenient.


스크린샷 2024-11-04 141102.png

스크린샷 2024-11-04 141305.png

 

Status: Accepted

Hi @juan007105 ,

 

Thanks for the details and I can reproduce your issue.
I have reported this issue on the internal platform and once the PG team has made any progress I will update here in time, thanks for your patience!

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @juan007105 ,

 

I tried to do the following test to try to reproduce your problem but it didn't work, since I don't understand Korean very well, could you provide your sample in the comments below so that we can reproduce your problem better, any detailed explanations would be greatly appreciated.

 

vxiaoyanmsft_1-1730705210830.png

 

 

Best regards.
Community Support Team_Caitlyn

 

 

 

juan007105
Regular Visitor

 

스크린샷 2024-11-04 163623.png

 

It is same as your picture

Column-name part is ok, But when I type any korean text in the column-function part, the error occurred.

 

For example, when I try to type Korean alphabet "ㄱ" in "금액", then error occured like this picture.

And 1 more alphabet "ㄱ" added as "ㄱㄱ".

( type "ㅅ" then "ㅅㅅ" & error message pop-up

/ type "ㅇ" then "ㅇㅇ" & error message pop-up

/ type "ㅕ" then "ㅕㅕ" & error message pop-up

/ type "ㅏ" then "ㅏㅏ" & error message pop-up)

 

 

 

스크린샷 2024-11-04 164139.png

 

 

This is the sample code.

 

let
원본 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyNjE1U4rVgTAtTKFME1MLQzDTzNTEwtAYzLQ0NTc1g4gamgN1WSjFxgIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [금액 = _t]),
#"변경된 유형" = Table.TransformColumnTypes(원본,{{"금액", type number}}),
#"추가된 사용자 지정 항목" = Table.AddColumn(#"변경된 유형", "평가", each if [금액] >= 900000 then "높음"
else if [금액] >= 600000 then "중간"
else "낮음")
in
#"추가된 사용자 지정 항목"

v-xiaoyan-msft
Community Support
Status changed to: Accepted

Hi @juan007105 ,

 

Thanks for the details and I can reproduce your issue.
I have reported this issue on the internal platform and once the PG team has made any progress I will update here in time, thanks for your patience!

 

Best regards.
Community Support Team_Caitlyn