How to make PowerPivot Case Sensitive

Question

In SAP we have more than 30 tables using the field MATID that is needed to connect them to retrieve data. these are 22 Char long fields looking like this LyyRf{JY7j{5yA90GdFL1W. When we have another material it can have MATID LyyRf{JY7j{5yA90GdfL1W and now I have a double value. Cleaning this manually (I add my name behind the value with the Caps F also to find them back easy) is a lot of work. Is there a better easy way to deal with this issue?

Answer 1

Hello @Jaap van Neerven,  

Thank you for reaching out to the Q&A forum! 

For your situation, please take note this point: 

PowerPivot currently does not have an option to enable case-sensitive matching.  

I agree with you that manually adjusting values is very time-consuming, especially when you have a large volume of data. 

When I researched this, I found that there are some workarounds that might help, such as using Power Query to create a case-sensitive dimension table and surrogate keys before loading data into the Data Model.  

However, I hope you understand that working with such advanced transformations is outside the standard support scope, and I have limited ability to fully test this in my environment. 

If you would like to explore a workaround or need deeper technical guidance, I highly recommend posting your question on:

•  Home | Microsoft Community Hub
• Newest Questions - Stack Overflow   

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link 

These platforms are the large technical community where developers and data professionals frequently share solutions to complex scenarios involving Excel, PowerPivot/Power Query, APIs, and automation.    

They are focused on technical topics and include experienced moderators and professionals who can offer deeper guidance and practical insights.  

I also found a post discussing a similar case-sensitive issue, and moderators in that forum were able to provide helpful guidance: Case sensitive problem in Excel’s Pivot Table.

I apologize for redirecting you to a different community. To help you receive faster and more accurate assistance, I’m guiding you toward a more appropriate platform where your questions can be addressed more effectively.  

Thank you for your patience and understanding; I truly appreciate your time and cooperation. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.