Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How do I add a Salesforce Connection as a data source in corporate gateway?

So I have various reports that pull from Salesforce objects. It works great and I'm able to have Power BI refresh on a regular basis through my personal gateway.    I'm trying to migrate all of my ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

    Based on  your description, when you combine on-premises data source and Salesforce data source in a dataset, you are not able to use on-premises gateway to set refresh for the dataset, right? If that is the case, the issue is caused by that on-premises gateway doesn’t work with online data sources, this is a known issue  that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review, , please vote it.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

    To work around the issue , please use the personal gateway to schedule refresh for your dataset when combining Salesforce data source and other on-premises data sources.


    Thanks,
    Lydia Zhang

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

The Enterprise Gateway is for on-premises resources. Salesforce does not need to be added because it is a cloud-based source so it is updated with the "cloud gateway" (Power BI Service)

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Greg_Deckler, 

Thanks for the reply.

 

So I have two reports. They both have the same files as data sources, with the exception that Report B is connected to a Salesforce object. 

 

I've been able to switch Report A (without Salesforce) from my personal gateway to the corporate gateway, no problem. But I've been unable to switch Report B to the same, corporate gateway. The only difference is that I have the Salesforce data source in Report B. 

 

I don't even have the option to switching to the corporate gateway in Report B. 

 

If the Salesforce connection is "in the cloud" and I don't have to make a specific Salesforce Data Source within the Corporate Gateway itself, I'm stumped as to how I can switch it from my personal gateway to the corporate gateway when all of the other data sources exist.