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...
pablobarra's avatar
pablobarra
Advocate I
8 years ago

Hi ben1

 

You should be able to do it by using \get data\from Salesforce and seect "custom" instead of "production".

"Custom" option allows you to connect to a Sandbox and to Production.

You need to add the url of your "production" environment (like https://eu14.salesforce.com/)

If you have more than one instance of SFDC in the same environment, you can use "login.salesforce.com", "emea.salesforce.com, etc.

Pablo

andreamastrini's avatar
andreamastrini
Frequent Visitor
6 years ago

Hi -

I have 3 Salesforce orgs to connect and I unfortunately selected "Production" while connecting the fist one. I tried to export the dataflow to json and import it as a Model into a second dataflow but PowerBI doesn't give me the option to select the credentials for each org.

What am I supposed to do? Recreate the (long) dataflow coping and pasting the M code for each table OR there 's a central place where to manage Salesforce org's credentials in PBI service?

Thanks!

Andrea