Power BI transforms alphanumeric columns containing uppercase letters into lowercase ones

[Professor_Luis]

I am using a column as the key of my table, this column is alphanumeric and has the following values:

002F+fc

002F+fC

002F+Fc

002F+FC

When loading the Power query into Power BI, it transforms it into values ​​like this on its own:

002F+fc

002F+fc

002F+fc

002F+fc

How to solve?

tks..

[Professor_Luis]

Because it's a bug shouldn't we report it? In my work, I use this column as a key to consolidating bases.

[Anonymous]

Hi @Professor_Luis ,

Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Professor_Luis ,

This seems to be a known bug in power query, where whatever size type of letter is exported from power query becomes lowercase.

Below is my table:

After power query:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.