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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.