Bug in PowerQuery

[Anonymous]

When importing case sensitive 13-digit salesforce IDs (from XLS or CSV), the ID's are correctly imported when shown in the data conversion UI (PowerQuery). When showing in DataView or ReportView some IDs are modified (single digits changed from uppercase to lowercase or vice versa) This creates wrong and unusable ID's.

Example:

let
Quelle = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjAwMw4zAAFH8/JcLyUdJf+CAkOlWB10qSyIlJFSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [OppID = _t, OppName = _t]),
#"Geänderter Typ" = Table.TransformColumnTypes(Quelle,{{"OppID", type text}, {"OppName", type text}})
in
#"Geänderter Typ"

The OppID in Row2 Column1 is: 0063V00000A7wmj

That's what the PowerQuery-Editor shows correctly.

When opening the same Table in Data-View or Report-View the same ID is suddenly

changed in it's last digit from lowercase to uppercase.

Why is this happening ?

[Anonymous]

Hi @Anonymous ,

PBI is case-insensitive. The display will show the value that comes first.

You can also find the same issue has been talked in forum many times here 

Please see if it helps.

Create a Dimension Table with Power Query: Avoid the case sensitivity bug! 

Best Regards,
Community Support Team _ Caitlyn