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...
djurecic
Super User
Super UserHi KumbharM ,
This is the expected behavior.
You can either apply formatting to the excel file, or use a PowerQuery function like text.Upper to make the change when loading data:
https://learn.microsoft.com/en-us/powerquery-m/m-working-with-case
Also see: