Power Query Load not maintaining case sensitive data RRS feed

  • Question

  • I am pulling Salesforce data using Power Query. The Salesforce iD is a case sensitive alpha-numeric value. When I see data in the Power Query edit window I see the Ids correctly. However, when the data is loaded into Excel the it's showing in all upper case thus causing duplicate IDs to exist. Why is that and how can I avoid it?

    Thursday, December 24, 2015 1:41 PM