Power Query - Automatically changes text column to uppercase

[AndreasITUK]

Good morning,

We stumbled upon a odd situation today, we got a composite key column which is case sensitive which caused some issues today. We found that values during the data preview during transformation is shown correctly but once saved/loaded shows in all uppercase.

I cannot find this as a setting or understand why this occurs, is this per design or a bug?

Source: Power BI Dataflow

Column Name in below picture: CUSTOMER_GROUP

Column definition: Text

Desktop app version: Version: 2.108.603.0 64-bit (August 2022)

[v-xiaoyan-msft]

Hi @AndreasITUK ,

I was not able to reproduce your problem, it is working fine with me, this may be a temporary problem, did you check if it works today?

Best Regards,
Community Support Team _ Caitlyn