juan007105's avatar
juan007105
Regular Visitor
1 year ago
Status:
Accepted

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.


 

3 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

     

     

     

    Best regards.
    Community Support Team_Caitlyn

     

     

     

  • juan007105's avatar
    juan007105
    Regular Visitor

     

     

    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)

     

     

     

     

     

    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
    #"추가된 사용자 지정 항목"

  • Anonymous's avatar
    Anonymous
    Not applicable

    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