Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have several salesforce tables in my dataflow. They have always worked outside the gateway that we use to refresh into SQL. When I go into edit my dataflow today all my connections to Salesforce are broken and want me to reconnect - I cannot - invalid credentials. I can fix it by trying to add a new Saleforce connection and specifying that to come through our gateway to the SQL tables (weird but it seems to make everything connect and work). Then I can save it all including my changes (if I do not do this it will not save the changes because of erors in all the salesforce tables).
The dataflow refreshes OK - I just get this connection issue when I go in to edit anything. I know Salesforce are changing loads of stuff at the moment - but this just seems too odd. Anyone else having problems or is it just me?
Solved! Go to Solution.
Ok I have found the solution. Someone had added a new datasource into our main gateway being a salesforce login. So I think the systm was getting confused by how it was meant to connect to saelsforce. Once I removed that datasource from the gateway it sorted itself out. Thank youf ro taking the time to show an interest.
What do you mean when you say "Salesforce tables" ? Salesforce has objects and attributes, it doesn't have tables.
Objects.
Any sudden changes in object sizes or relationships? Do you have the same issue with DataLoader?
Ok I have found the solution. Someone had added a new datasource into our main gateway being a salesforce login. So I think the systm was getting confused by how it was meant to connect to saelsforce. Once I removed that datasource from the gateway it sorted itself out. Thank youf ro taking the time to show an interest.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 48 | |
| 46 | |
| 44 | |
| 16 | |
| 15 |