Salesforce -> PowerBI and GUID

[smoothbrain]

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, 

[danextian]

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.

[smoothbrain]

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! 

[danextian]

There probably are other objects there that contain the username or whatever field Joe Bloggs is and the GUID equivalent.