Forum Discussion
Salesforce: Failed to update data source credentials
I too have run into the same error as the OP. Nearly the same exact scenario with the same results:
- Custom Salesforce domain
- Connceting directly to Salesforce objects
- When configuring gateway options, click 'edit credentials' for the Salesforce connection
- Input correct login information, window closes as if the connection was made
- End up with this error:
"
Failed to update data source credentials: Hide details
| Activity ID: | 06cce81c-aaba-481c-87b4-47b6c8d13af9 |
| Request ID: | 3cdf6720-3e6f-1e94-ec31-8224980df5dd |
| Status code: | 400 |
| Time: | Thu May 02 2019 08:14:07 GMT-0400 (Eastern Daylight Time) |
| Version: | 13.0.9264.166 |
| Cluster URI: | https://wabi-us-gov-virginia-redirect.analysis.usgovcloudapi.net |
"
This too is a deal breaker for mt organization since the bulk of our data is now in Salesforce.
At this time I am manually updating our reports in Power BI Service by refreshing and republishing through the Desktop client, but this won't be an effective long term solution. Is there any workaround to get the scheduled refresh option to work with the Service?
I have narrowed my problem to IP ranges whitelisted by my company... working it with my IT dept which is slow and fun.
Good luck
Anonymous When you and your IT team find the solution, can you please let me know what IP's needed to be whitelisted? It'd be a great help! Thank you!
Hi Anonymous ,
Can you please share the solution?
Regards,
Keerthi
This worked for me after I disabled this setting in Salesforce.
"Salesforce session settings can block this integration. Ensure that the setting Lock sessions to the IP address from which they originated is disabled"
