Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
smoothbrain
New Member

Salesforce -> PowerBI and GUID

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, 

3 REPLIES 3
danextian
Super User
Super User

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.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!