I’m creating a model from Data in Salesforce and just found that as many of the Key Columns are Case Sensitive, I cannot create a relationship between my Opportunity Table and Accounts Tables, using the Account ID from the Opportunity Table as a *:1 releationship in PowerBI complains about duplicates when there are none.
Columns = Opportunity ID, Account ID
Columns = Account ID, Account Name
0015000000KCouT, Account B
0015000000KCout, Account A
Any way to get around this so I can create the relationship, otherwise I will have to add the data I need directly to the Opportunity Table as additional columns, which I would like to avoid, before I load the data into PowerBI.