Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI transforms alphanumeric columns containing uppercase letters into lowercase ones

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..

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

      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's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    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.