Change in cases from query editor to desktop

[Anonymous]

Hi,

I have this strange issue, that when I use my data in the desktop, some of the Opportunity ID's from Salesforce changes the case of the last letter. 

In the query editor, the data looks fine: 

Two different opportunities with almost the same ID, as the last letter is uppercase in the first ID and lowercase in the second ID. 

But when I load it into the desktop, it recognises the two ID's as one ID. It changes the last letter in the second ID to an uppercase 'A': 

I am not sure if it has anything to do with the case sensitivity bug, but have anybody encountered the same issue or are able to help out?

Thanks in advance for any help.  

[v-eqin-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Eyelyn Qin

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

From my research , it's  by design now. As Power Query is case sensitive while data model isn't.

This is at idea/feedback level alone. May be , hopes Power Bi will implement this in nearby future.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback -https://ideas.powerbi.com/ideas/idea/?ideaid=a9843990-64f6-ea11-b5d9-281878bdaa58

In addition, you could  refer to this blog for help: 

Create new Blank Query, paste the following operation in Advanced Editor.

let
    Source = 
    #table(
        type table 
        [MyTextColumn = text], 
        {
            {"A"},
            {"a" &Character.FromNumber(8203)},
            {"B"},
            {"b" &Character.FromNumber(8203)},
            {"c" &Character.FromNumber(8203)},
            {"C"}
        })
in
    Source

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[nvprasad]

Hi,

PowerBi does some transformations while loading data automatically. Could you please check Power Query Editor transformations in the Advanced Editor and delete any unnecessary transformations that appears.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad