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,

I am also loading a Sales Force URL and I am having a similar issue. It looks look the issue is native to Power BI as DAX/the model is not case sensitive and Power Query is. So the model alters the letters when they are loaded. Not good for a URL!

I doesn't seem to me that a satisfactory solution was given. Did you ever resolve this issue? And if so what did you do?

 

Thanks,

Rob

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

Hi Rob,

I ended up creating a new column using a basic

CONCATENATE("https://YOURCOMPANY.my.salesforce.com/", [Opportunity  Internal ID])

Salesforce was pretty clever - the internal ID of an opp is also its link.

Hopefully it works for you too.

Alice