You need to sign in to do that
Don't have an account?
Nathan Prats 17
Power Query and Salesforce. Add fields via Lookup
Hi,
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 ?
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 ?
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.Regards,
Nagendra.