Forum Discussion
Solved
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...
Hi 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:
v-kathullac
Community Support
Community SupportHi KumbharM ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
Regards,
Chaithanya.