+ Start a Discussion
Nathan Prats 17Nathan Prats 17 

Power Query and Salesforce. Add fields via Lookup


I need to add fields via lookup in my M Language (Excel Power Query Language) Statement. 
For instance, a SOQL query would be SELECT Id, Profile.Name FROM User. 
With Excel Power Query, I can't figure out a way to add the Profile.Name in my statement.
I only can return ProfileId. 

Any Idea ? 
NagendraNagendra (Salesforce Developers) 
Hi Nathan,

As the same post is answered in the success community as below
  • #"Expanded Profile" = Table.ExpandRecordColumn(#"Removed Other Columns", "Profile", {"Name"}, {"Profile.Name"})
Please mark this as solved so that it gets removed from the unanswered queue which results in helping others who are encountering similar issue.