Power BI converts first character to upper

[Anonymous]

Hi All,

I have a dataset which has a value head and neck in sql server but when I have loaded the data in power bi it's getting converted to Head and Neck. (the "and" a is small only)

Any idea about this scenario?

Thanks,

Sukun Jain

[jpt1228]

Hello @Anonymous  You don't state why this is an issue - But I see 2 ways to solve. Directly through the SQL string, or bring the data in and do the transformation in Power Query - Select the column and then under transform click format, and then lower case.

[Anonymous]

The concern is not related to transformation. I am just calling select * from tablename and I am not performing any transformation in sql or power bi but the value is getting changed from "head and neck" to "Head and Neck"

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may check the posts below.

• https://community.powerbi.com/t5/Desktop/Issue-with-Data/td-p/330446
• https://community.powerbi.com/t5/Desktop/Key-value-in-lowercase-automatically-converts-to-uppercase/td-p/370660
• https://community.powerbi.com/t5/Desktop/Generating-unique-keys-from-case-sensitive-data-in-Power-BI/td-p/42050