Power Query and Salesforce RRS feed

  • Question

  • When I import data from Salesforce using Power Query, the ID's instead of names were imported.  For example, instead of owner name, it was the owner ID, and instead of account, it's account ID.  How do I get the names to appear?  Not sure if relevant, but I was importing data from a custom object.  Thanks in advance!
    Wednesday, July 26, 2017 9:09 PM


  • You would have to join to the appropriate table in order to get the related information. One way to do that is to pick the option which includes navigation columns and to expand the navigation column in the query editor to get the field you want.
    Saturday, July 29, 2017 1:56 PM