Forum Discussion

AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
6 years ago
Solved

URL link changes capital letters to regular ones after loading Power Query. Why?

Hello everyone,   I have a report which takes data from Salesforce. Each Opportunity has its own URL like: https://mycompany.my.salesforce.com/00abC   I've encountered one case where two Opportu...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi AliceW ,

    "And I couldn't figure out what you mean by the blank."
    I mean insert a space before a1.
    Actually for this problem, there are currently two possible solutions:

    1. Use M language

    https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/ 

    2. Modify value
    Just like I did before, insert the corresponding characters in the column value to distinguish the column value.

    Best regards,
    Lionel Chen

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

zelroberic's avatar
zelroberic
Frequent Visitor
6 years ago

Hi Alice.

Ok this makes sense.

I am actually in an Invoice table and it appears that the ID also has letters in it. I will speak to our Sales Force administrator to get more clarity. Thanks for getting back to me so fast. I don’t under why this issue doesn’t come up a lot when pulling information from the web.

 

Thanks Rob

AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
6 years ago

Cool, you have invoicing in Salesforce! I think the logic behind the 'Internal ID' is the same. I know I use it for Leads too.

  • zelroberic's avatar
    zelroberic
    Frequent Visitor
    6 years ago

    We import our invoices from NetSuite our ERP system so our Sales people can have access to their Sales and Orders.

    Interesting I didn't see the field [Operational Internal ID] at first glance. I will look again. The [ID] field I saw still contained 

    letters. The internal ID is totally numeric? 

    Thanks for your help so far. I really appreciate it.

    Rob

    • AliceW's avatar
      AliceW
      Icon for Power Participant rankPower Participant
      6 years ago

      Hi Rob,

      The internal ID is (for us) a combination of letters and numbers, such as 0063MX90004qzCN. The field is definitely there, as it's used by Salesforce as an unique identifier for a particular record (Opps, Accounts, Users etc.). It should have 'internal' in the name. Your IT department should have made it visibile though (or perhaps it's just me) 🙂

      Good luck!

      Alice

      • zelroberic's avatar
        zelroberic
        Frequent Visitor
        6 years ago

        Alice,

        It Worked!!

        Though I have to admit I don't know why it should work as the ID also has lowercase and uppercase letters that could also change their case. But somehow it doesn't. Something is different, but I don't know what.

        How did you realize this could be a solution?

         

        Thanks again for your time in solving this issue.

        All the best,

        Rob