Salesforce permissions in power query for multiple organizations/environments
When using Power Query to access objects in Salesforce, the only login choices that are saved are for Production or Sandbox.
Salesforce uses the user ID to determine which Production Organization or Sandbox we're accessing. Because we do work for multiple organizations, it would be useful to have the connection information stored with the workbook instead of centrally with Excel. Having to clear the permissions every time I switch a spreadsheet I'm working with is frustrating.
Thanks! (Couldn't live without Power Query!)