Forum Discussion
How do I add a Salesforce Connection as a data source in corporate gateway?
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
Interestingly enough when I modify the report to only include a Salesforce Object as a data source, I get a different Gateway option that says "Connect Directly".
Now when I add another data source (that both my personal and corporate Gateway has access to), the Gateway options change to only show my personal gateway. I've tried an Excel file and SQL database connection as data sources (that have been able to connect to the corporate gateway before), and I still only have the personal gateway as an option.
It seems as though I cannot have both a Salesforce data source and any other data source, in order for the Corporate Gateway, to be an option which just boggles the mind.
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
Anonymous,
Very good. Thanks for the head's up. I've gone ahead and voted for that feature.
I can see that this suggestion has been marked as finished. However, my connection to salesforce cannot be added to the enterprise gateway as below