Text values have different case in Table View than in Power Query causing less unique values

[CarmenTurnagiu]

Hi Community, I need your help to understand why in the table view I see different values than in Power Query and in the data source.

As a result the number of distinct values for the Order State field is lower in Table View than in Power Query.

Please note that I have the latest version of Power BI Desktop and refreshed the data in both views.

Thanks for your help,

Carmen

[Greg_Deckler · Accepted solution]

@CarmenTurnagiu Because the first obvious feature that you want in a data analytics tool is for the tool to immediately munge your data, Power BI's semantic model is stupidly case insensitive in that the first instance of a word is the casing that will be adopted for all instances of that word. It's the absolute dumbest thing imaginable that Power BI does not allow you to turn off this "feature" (because the tabular data model doesn't have to be implemented this way). Here's a video I made on it:

[CarmenTurnagiu]

Many thanks for your reply @Greg_Deckler Greg. It is confusing and difficult for me to understand why power query would be case sensitive but power bi engine not.  

[Greg_Deckler]

@CarmenTurnagiu Incredibly poor design.