Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Not applicable

Salesforce connection refresh from gateway with other sources configured

Hi there,


I'm updating a report that currently has multiple sources, such as on-prem files, odbc connectors, and some other items. This report is currently published to a gateway, and is scheduled to refresh from that gateway multiple times a day.


I'm adding in Salesforce reporting, using the PowerBI default Salesforce connector. It works great locally, I can refresh and all, but when publishing out to the server I get message "Salesforce cannot be added to gateway". I've read numerous posts on this forum about how to have both web connectors & gateway connections, but don't quite get it. Is this possible? Can I keep my other sources refreshing, while also having a daily refresh from Salesforce?



Helper III
Helper III

Hi @Ajay346 I don't know if a solution was found for this was found but in case you only have SF as a data source, I think there's no need to use a gateway to keep the report updated. As a workaround, maybe you can try to test your connection with a 3rd party connector. I currently use's SF connector to pull my data and it works great so far. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:




After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:




There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 



Regular Visitor

Hi we're you able to find any solution for it . ?  

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.