Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey team,
Apologies for the daft question - I'm admittedly not super across PowerBI, and it's just now become part of my position.
I'm currently using the Salesforce CRM system. I've dabbled in Power BI, and am vaguely across the interface now. I've successfully imported data from Salesforce objects into Power BI, however I seemingly get a lot of GUID for particular fields (such as users, record types etc...).
Is there a way in which I can convert these ID's back to the Salesforce value? It's making data analysis somewhat problematic and confusing when I can't decipher what anything is.
Cheers,
Hi @smoothbrain
I used salesforce before and those GUIDs should have some kind of more understandable equivalents in the object itself. As far as I can remember, those can be used as primary and foreign keys to relate different tables in the semantic model. They're also in the URL when, say, you open an opportunity in SFDC website. I would use what's in the website to match what is in the SFDC object. Otherwise, there's nothing much Power BI can do if those information is not made available at all.
Proud to be a Super User!
Hey, @danextian
You're absolutely on the money! I can see that the GUID's match the particular case and/or staff member in the URL.
The issue I'm having, is in PowerBI, I was hoping to display "Joe Bloggs" rather that the associated GUID associated with that field.
Thanks for the assistance thus far! I appreciate it!
There probably are other objects there that contain the username or whatever field Joe Bloggs is and the GUID equivalent.
Proud to be a Super User!