Forum Discussion

Gene2020's avatar
Gene2020
Frequent Visitor
6 years ago
Solved

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 an...
Need Help
az38's avatar
az38
Community Champion
6 years ago

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

Gene2020's avatar
Gene2020
Frequent Visitor
6 years ago

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.