Difference between Query Editor & Desktop

Hi BI_MI, 

I tested on my side but not able to reproduce the issue. Please update Power BI desktop to the same version. Also you can try the Power Query to create the same report as ours then test again on your side to see if the same issue occurs. 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnY0MNQ3MDA0MTNW0lEyVDAwMNAxMFBwdVSK1YHLGhmaGIFkYTKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Material/ Plant(Key)" = _t, #"Base Qty for Price(Key)" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Material/ Plant(Key)", type text}, {"Base Qty for Price(Key)", type text}})
in
    #"Changed Type"

Best Regards,
Qiuyun Yu

Hi.

Thanks for your reply. I have tested with the latest version of Power BI (December) but I still have the same issue.

When applying your code it works well and have the expected result without converting text format.

Which code I have to apply to solve the issue ?

Thanks for your help.

Hi BI_MI, 

In Query Editor, please select the column, then change data type as TEXT, apply the change then check if the same issue occurs. 

Best Regards,
Qiuyun Yu