Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
Gene2020
Frequent Visitor

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

1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

@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

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

8 REPLIES 8
Robert14358
Resolver III
Resolver III

why would Microsoft do this? it really hurts finding errors in data if it changes the case sensitivity on my data lol

az38
Community Champion
Community Champion

@Gene2020 

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Gene2020
Frequent Visitor

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.

az38
Community Champion
Community Champion

@Gene2020 

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Gene2020
Frequent Visitor

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
Community Champion
Community Champion

@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

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Zyg_D
Continued Contributor
Continued Contributor


@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 

Gene2020
Frequent Visitor

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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.