Power BI Desktop thinks "Aaa" and "aaA" is equals

[googlogmob]

Is there any way to set for Power BI Desktop to use Aaa and AAa as different values?

E.g. collation in SQL Server

[hugoberry]

You can read more about this here https://dennyglee.com/2010/06/18/powerpivot-you-are-so-insensitive-case-that-is/

The article also contains some workarounds.

[googlogmob]

There is not any solution

[KHorseman]

It would help to know if you're having trouble with case sensitivity in a query or in a DAX formula. The solutions for each will be completely different.

[hugoberry]

Just to aid the conversation whomever is interested to reproduce the problem, try applying the following query

=#table(null,{{"aaa"},{"AAA"},{"aAa"}})

and check your results in either data model or the report view.

As per initial question from @googlogmob there is no such thing as collation in Power Query/Pivot that would be obvious to apply.

If the columns with Aaa and aaA are not meant for reporting I would suggest transforming their contents in Power Query to binary Text.ToBinary(). 

[googlogmob · Accepted solution]

We added custom column in Query to create distinct values for key field:

= Binary.ToText ( Text.ToBinary([campaignId]) ) & [campaignId]

[Phil_Seamark]

Can you use the EXACT function?

eg, 

Measure 2 = EXACT("AAA","aaa")

returns FALSE

while 

Measure 2 = EXACT("AAA","AAA")

returns TRUE