Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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
Thanks for the information. What I am saying is that when I choose a SQL table as a source file to load into Power BI Desktop, the field that has customer contracts (a 2 digit field) is converted to case the same case (without my intervention) and creates the wrong code in the table when loaded into Desktop. There is no step in the query editor when I look at it becauser there are only two steps. Source, and Navigation....and neither shows change case to upper. An example is: In the SQL table being loaded the contract could be 0A or 0a. When loaded the Power BI Table shows 0A for both of these; that is incorrect. It does this with any contract that has both upper and lower case combiniations (e.g. 1A and 1a will appear as 1A, 2B and 2b will appear as 2B, etc.). It has nothing to do with me applying transformations during the load, this happens as part of the import and I have no control over it as far as I can determine. That is what I am asking; can I stop the load from converting these codes automatically. Sorry I wasn't clear.
@az38 wrote:
@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-insensiti...
There are also a few possible workarounds in comments to this idea
Looks like the link is broken.
Is it this one?
https://ideas.powerbi.com/ideas/idea/?ideaid=a9843990-64f6-ea11-b5d9-281878bdaa58
Thanks for the link. I appreciate you taking the time to assist very much! I will deal with the issue in some other way until the Power BI team comes up with a solution.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
106 | |
64 | |
60 |