cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FionnAnseo Frequent Visitor
Frequent Visitor

Salesforce: Failed to update data source credentials

Hi Folks,

 

I have run into a pretty deal breaking issue at the last hurdle of building a fairly big report. The main datasource is Salesforce Objects, I was able to connect and run all perfectly via Power Bi Desktop but now I have finally got to publishing it and setting up the credentials it keeps failing. I have tried through my enterprise gateway and personal gateway with thes exact same result:

 

Failed to update data source credentials

 

Its a corporate instance of Salesforce on a custom domain and as mentioned works pretty much fine in Desktop. Has anyone any ideas why I might be running into this?

 

Its majorly heartbreaking to be at this late stage and run into this issue.

 

Any help welcome.

5 REPLIES 5
Community Support Team
Community Support Team

Re: Salesforce: Failed to update data source credentials

Hi @FionnAnseo 

If instance of Salesforce is online, you don't need to add this data source under any gateway,

just go to setting->schedule refresh->edit credential,

before that, be sure "Allow user's cloud data sources to refresh through this gateway cluster " checked.

5.png

If it doesn't help, please provide detailed error information.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

FionnAnseo Frequent Visitor
Frequent Visitor

Re: Salesforce: Failed to update data source credentials

Thanks, I tried this, it will not save the credentials... it seems that its a setting on the instance of Salesforce as I can do it fine with an alternative instance of salesforce...


It would be better if I COULD push Salesforce through the gateway but it doesnt work that way.

velezdsa Frequent Visitor
Frequent Visitor

Re: 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?

FionnAnseo Frequent Visitor
Frequent Visitor

Re: Salesforce: Failed to update data source credentials

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

velezdsa Frequent Visitor
Frequent Visitor

Re: Salesforce: Failed to update data source credentials

@FionnAnseo 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!