Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Everyone,
I am relatively new to Power BI and I am trying to create a relationship between an export from Salesforce.com (CSV) and ExactTarget (CSV). The challege I am running into is that the GUID Salesforce uses is case sensitive and power bi doesnt recognize case sensitive fields. When I try to connect the two tables I get an error due to distinct values.
Is there a workaround for this?
Thanks
Hi @oskardiazdeleon, if the records are meaning the same and are duplicates like "Tom" & "tom" is the same then you can use powerquery to import ( PowerQuery is case sensitive ) but you need to transfrom it to Text.Proper() and remove duplicates.
I wrote a post long ago , you can check it if you think it can help you..
Thank you @konstantinos. I appreciate your expeditious response. Is there a way to enable a case sensitive field in Power BI?
I noticed that Power BI has an integration with Salesforce.com. If i leverage this feature natively and not through a a CSV ,these challenges are removed. Is there something unique that the integration does to the exact same data set?
-Oskar
Just add an index field in Power Query when you're importing the data, then use that to join on.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.