Words are automatically being capitalized after importing to power bi

[hemanth_423]

I have two rows: one with "Srinivas" (with an uppercase "S") and another with "srinivas" (with a lowercase "s"). In the Power Query Editor, the rows display correctly, but after loading them into Power BI, the row with the lowercase "s" is automatically converted to uppercase. Is there a way to prevent this?

Thanks in advance

[Bibiano_Geraldo · Accepted solution]

Hi @hemanth_423, this is known issue as you can see here: Case sensitive trouble Power Query -> DAX 

What i recomend to you, its to add a index for each row as ID to bypass this issue.

If this help you, please give a Kudo and mark it as solution.

Thank you

[Anonymous · Accepted solution]

Thanks for the reply from Bibiano_Geraldo , please allow me to add some more information:
Hi  @hemanth_423 ,

According to the official documentation description:

This change happens because Power Query Editor is case sensitive, so it shows the data exactly as stored in the source system. The engine that stores data in Power BI is case insensitive, so treats the lowercase and uppercase versions of a character as identical. Power Query data loaded into the Power BI engine can change accordingly.

Data types in Power BI Desktop - Power BI | Microsoft Learn

You can check out the following link on how to make Power Query case insensitive by customizing M:

Solved: How can i use Case Sensitive feature in power bi - Microsoft Fabric Community

This is the related document, you can view this content:

Letter case-sensitivity in DAX, Power BI and Analysis Services - SQLBI

Best Regards,

Liu Yang

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

[Bibiano_Geraldo · Accepted solution]

Hi @hemanth_423, this is known issue as you can see here: Case sensitive trouble Power Query -> DAX 

What i recomend to you, its to add a index for each row as ID to bypass this issue.

If this help you, please give a Kudo and mark it as solution.

Thank you