Forum Discussion

phi2134's avatar
phi2134
Helper I
9 years ago

Advanced Query Editor to change Salesforce Object Credentials

Is it possible to change your SFDC object credentials within the Advanced Query Editor?  I need to bring in SFDC objects from multiple SFDC instances and since you cant have multiple accounts logged ...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

phi2134

 

No, Power Query only call Salesforce.Data() function, it's not possible to edit credential within Query Editor.

 

 

Regards,

  • wildingcd's avatar
    wildingcd
    New Member
    8 years ago

    Is there a workaround that would allow multiple Salesforce datasets?  We need a to be able to aggregate data across mulitple Salesforce orgs.

    • phi2134's avatar
      phi2134
      Helper I
      8 years ago

      Nope, not that I know of.  This is currently not possible and we are facing the same issues still.  The only option we ahve right now is to upload multiple sfdc datasets from different pbix files to the same workspace, there they can at least be shown together on a single dashboard, but not in a single report.