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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Power BI treats text values in the semantic model (VertiPaq / DAX engine) as case‑insensitive.

Power BI treats text values in the semantic model (VertiPaq / DAX engine) as case‑insensitive. While Power Query (M) is case‑sensitive, once data is loaded into the model:
Status: New
Comments
andyclap
Advocate IV

Always been this way. One of those things you need to be aware of when dealing with data systems.

 

Same goes for your upstream datasources, some will be case sensitive, some non-sensitive. Some with regionalized fields with different casing rules.

 

Mainly annoying when dealing with case-distinct data ... I've sometimes seen encoded id fields that differ by case. Nightmare.