Forum Discussion
Scheduled refresh from Salesforce not working
Hi,
We have a report that takes data from on-prem Excel spreadsheets and Salesforce. We want to schedule a refresh of this data at last once a day. We have an Enterprise Data Gateway setup and running with the latest version of the software. When we go to configure the refresh for the data Power BI asks for the data credentials to be updated because they are invalid.
Clicking on Edit credentials brings up a login screen for Salesforce. We type in our username and password, Salesforces asks for permission for Power BI to access Salesforce which we approve. Then we get the following error message:
Failed to update data source credentials: Hide details
| Activity ID: | ec17ccd0-ea6c-4c1a-99f0-400cd1346005 |
| Request ID: | 821457b5-eaad-0370-ce01-3b44f2dcc776 |
| Status code: | 400 |
| Time: | Fri Oct 06 2017 10:00:24 GMT+0100 (GMT Daylight Time) |
| Version: | 13.0.2671.164 |
| Cluster URI: | https://wabi-north-europe-redirect.analysis.windows.net |
Does anyone know what the issue might be or how to solve it?
Thanks,
Craig
Looks like it was the configuration of our Salesforce only allowing whitelisted IP Addresses connectivity and our Azure tenant wasn't listed.
3 Replies
Looks like it was the configuration of our Salesforce only allowing whitelisted IP Addresses connectivity and our Azure tenant wasn't listed.
C_Wilson Can I ask what ranges you needed to open I am getting the same issue in my company.
It seems that your problem has been resolved by yourself. Thanks for sharing the root cause.
Best Regards,
Herbert
