Forum Discussion

sipati's avatar
sipati
Microsoft Employee
5 years ago

Display case sensitive values in DirectQuery PowerBi

Sql Query -      CREATE TABLE dbo.abctest ( id int, [name] varchar(20) ); insert into abctest(id, [name]) values (1, 'tree'); insert into abctest(id, [name]) values (2, 'Tree'); insert ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  sipati ,

 

You can try to select "query settings" in the right pane in power query, delete the "uppercase text" step, or go to the advanced editor to delete such information

#"Uppercased Text" = Table.TransformColumns(#"Changed Type",{{"Contract ID", Text.Upper, type text}})

 

There are also similar questions for you to check. I hope it can help you:

https://community.powerbi.com/t5/Desktop/Table-visualization-and-case-sensitivity/td-p/330455

https://community.powerbi.com/t5/Desktop/Ignore-Case-sensitive-data-in-a-table/td-p/531849

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

sipati's avatar
sipati
Microsoft Employee
5 years ago

Hi, Thanks for the reply. I don't have such steps which is manipulating the cases, I want to preserve the cases and display them as it is, but powerbi is unable to -

Also, the actual field is going to be 50 characters long, so it is not possible to compare each character and append zero-width space for each lowercase/uppercase character to manipulate without changing storage mode to import (as Power Query might not support directquery)