Forum Discussion

ben1's avatar
ben1
New Member
8 years ago

Connect to multiple Salesforce orgs at the same time?

I am testing Power BI. The Salesforce connector works well.   However, we have multiple Salesforce orgs and I am wodnering if it is possible to connect to each of them and pull data from each org i...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I had the same issue for my dataflows and did something similar to what is suggested in some responses above, but in the M-code.

 

By default, Power Query will produce the following code:

Source = Salesforce.Data(),

 

You can replace by:

Source = Salesforce.Data("https://yourdomainname.my.salesforce.com"),

 

Replacing "yourdomainname" with yours. Once this is done, Power Query will ask to authentificate, and redirect you to https://yourdomainname.my.salesforce.com.

 

If you have multiple Salesforce org under the same sub-domain as stated above (e.g. NA01.salesforce.com), a solution can be to setup "My Domain" feature in Salesforce setup. Doing so, you will choose the subdomain you want, that has to be unique.

Then, you will be able to put this unique login url in you m-code.