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:
maruthisp
Super User
Super UserHi KumbharM,
Data types in Power BI - Power BI | Microsoft Learn
Please check the above link for Data Types in Power BI.
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X