Forum Discussion
Query Editor changing case of SQL data
When I import a SQL table into Power BI Desktop the query editor is changing the text case to all Upper case. This is causing a real problem since the Contract ID field we use contains both upper and lower case. For example we can have a customer with a contract of 0A, and another customer with a contract of 0a. The query editor is changing both to 0A. How do I get the Query Editor to leave the case of text the same as the original source?
Thanks for your help!
Gene
- Gene2020
It’s surprising for me but I found the issue and idea like yours. You can support the idea by voting for it https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17235656-case-sensitive-insensitive-option
There are also a few possible workarounds in comments to this idea
8 Replies
why would Microsoft do this? it really hurts finding errors in data if it changes the case sensitivity on my data lol
just check right Pane "Query settings" in power query editor mode and remove step "Uppercased Text" or go to the advanced editor aand find and remove a row like
#"Uppercased Text" = Table.TransformColumns(#"Changed Type",{{"Contract ID", Text.Upper, type text}})do not hesitate to give a kudo to useful posts and mark solutions as solution
Thanks for the quick reply but there is no step to change case to upper text. The query editor in desktop appears to do this automatically. There isn't a step I can delete or change.
query editor can not produce any transforming step without record about it. you should check your data source
are you sure you are talking about query editor? are you sure you check it? maybe you should to refresh preview?
you can also share your pbix-file without sensitive data to check it
do not hesitate to give a kudo to useful posts and mark solutions as solution
