Scheduled refresh from Salesforce not working

[C_Wilson]

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

[v-haibl-msft]

@C_Wilson

It seems that your problem has been resolved by yourself. Thanks for sharing the root cause.

Best Regards,
Herbert

[C_Wilson · Accepted solution]

Looks like it was the configuration of our Salesforce only allowing whitelisted IP Addresses connectivity and our Azure tenant wasn't listed.

[Anonymous]

@C_Wilson Can I ask what ranges you needed to open I am getting the same issue in my company.