Forum Discussion

gcam032's avatar
gcam032
Icon for Helper I rankHelper I
3 years ago

PowerBI dealing with text case differently in M query compared to the data model

Hey Everyone,   I have a dim table that I'm creating from unique values of an existing column in my data model.   I'm taking a field of brands from customers and creating a dim with the following...
Need Help
priyanshugarg11's avatar
priyanshugarg11
New Member
1 year ago

I have a free text field in application where user entered values as

All products
ALL PRODUCTS
all products
All Products
But while loading the data from Power Query (Data source : Postgresql) to Power bi it is normalizing and displaying as 'all products' now my business team wants this to be display as it is available in application.

I checked and found that it is default behavior of Vertipaq engine but my business requires data as team is using these reports for compliance related