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

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

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.