Forum Discussion
Power BI automatically normalizing text casing during data load
Hello everyone, I am building a Power BI connector that loads data from a server and have observed an unexpected behavior with text values. For example, the source data contains the following value...
tharunkumarRTK
Super User
Super UserHello KumbharM
Yes this is an expected behavior.
To solve this problem I think there are few possible workarounds
- You can add additional characters, Chris webb wrote a blogs about the same
https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/ - You can change the collation in model.tmdl file, please refer the below video
https://www.youtube.com/watch?v=55Jekgmyai4
read my blogs here: https://www.techietips.co.in/