Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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.
User | Count |
---|---|
82 | |
42 | |
31 | |
27 | |
27 |