I think this issue has already been brought up, but I have found no resolution.

Power Pivot is case insensitive and therefore reports an error for duplicate values in a key field when they should not be considered duplicates. For example, ID numbers from Salesforce are ***EM7F and ***EM7f are being considered the same.

Please address this issue. Thank you.

Hi CMcReynolds,

According to your description, you need to enable case-sensitive primary key for power pivot data model, right?

PowerPivot automatically picks the collation based on the language you were working on. Collation is what determines the case sensitive nature. The default collation's are case insensitive. Currently, there is no a functionally for us to change collation.

If you have any concern about this behavior, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

Thank you for your understanding.

Regards,