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.

     

     

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi AliceW ,

 

For values of the same column, Power BI automatically converts lowercase to uppercase if the values are all the same except for letter case.

 

For example, here’s my original data:

Then, in Power BI data view:

 

As tested, we can use “Replace Values” feature:

(replace with: blank a1)

 

(replace with: url/)

 

Beyond that, there is no particularly good way.

 

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.

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

    The plot thickens.

    I actually have the code as a separate column ('Internal Code'), except it has 3 additional letters after the 'right' first 15 ones.

    I've tried trimming it with LEFT('Internal Code', 15), and it ALSO capitalized all letters except the first one.

    What is going on?

    And I couldn't figure out what you mean by the blank.. I've tried creating a new column as CONCATENATE(BLANK(),'Internal Code'), but I still got capitalized letters.

    I've also, in Power Query, tried creating a new column by trimming the 'Internal Code' to the first 15 characters, and it also capitalized them.

    That's a weird behaviour of my favorite software, guys.

    • v-lionel-msft's avatar
      v-lionel-msft
      Icon for Community Support rankCommunity Support
      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.