Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CarmenTurnagiu
New Member

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

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.

 

CarmenTurnagiu_0-1725546585052.png

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

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@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:



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@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:



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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.  

@CarmenTurnagiu Incredibly poor design.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.