Reply
Regular Visitor
Posts: 29
Registered: ‎03-08-2016

Key value in lowercase automatically converts to uppercase

Img1.PNGPower Query after extraction

img2.PNGAfter loading into model

In the above the first image shows A001 & a002 which are unique codes in oracle database.  After extraction and loaded to powerbi model, the a001 is converted to A001 which becomes a duplication.  Due to his problem I am not able relate with the transaction table.

 

Please help to resolve this problem.  

Community Support Team
Posts: 4,002
Registered: ‎07-09-2016

Re: Key value in lowercase automatically converts to uppercase

@Jayadev,

 

There is already an idea, you may leave a comment and vote it up.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.