PBI upcases US in text field -- very bad

[Syndicate_Admin]

I thought I was going blind or crazy.  In my data are addresses having variants of "US", "Us", "us".  I can see the values correctly in PQ preview.  When I apply and look at my table in PBI Desktop all instances are upper case "US".  I discovered this connecting to our SharePoint production source and then anonymized the file and imported as .csv -- same output.

Before:

After:

I've never seen anything like this and I do not want this behavior.  Please advise.

Thanks,

David

[jennratten]

@Syndicate_Admin 

I have validated this behavior and agree that it should not be happening.  I have increased the number of tests to narrow down the issue and Power BI seems to be automatically changing subsequent values that appear in a contiguous list to match the format of the first value.  The column headers and the record's values in other columns do not seem to influence the result. I have outlined the values below that have been changed.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WsoQDJR0l5/yUVEMgbWhkaKQQGqzgkZmeUZ5YqWCGQzBWB4sBRjC1pcWoBhgZGBggC1oYYDcAYVkxNhcUk+ACvWA9JK0wLgFbUTWFImmygAE8eiyAngzVK9ZTMAZ6LxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ssn = _t, ale_code = _t, address_1 = _t, Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ssn", Int64.Type}, {"ale_code", type text}, {"address_1", type text}})
in
    #"Changed Type"

[Syndicate_Admin]

Thank you for confirming.  I'm new to this forum.  Do you report such bugs or is it on me?

[jennratten]

I have reported this bug.  Values of a Different Case are Automatically Chang... - Microsoft Fabric Community